2498748
Questão 1
Questão
Which of the following is capable of producing a spreadsheet Tick all that apply?
Responda
-
Google Docs
-
Microsoft Office Excel
-
Microsoft Office Word
Questão 2
Questão
What word is used to describe re-organising the order of data?
Responda
-
Search
-
Filter
-
Sort
Questão 3
Questão
In a cell reference, for example A1, what does the letter refer to?
Responda
-
The row the cell is in
-
The column the cell is in
-
The worksheet the cell is in
Questão 4
Questão
Formulae must always start with which symbol?
Responda
-
Equals
-
Add
-
Brackets
Questão 5
Questão
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Responda
-
Present promotional information about a new television channel
-
Creating a budget for a party
-
Keep track of money raised at a charity event
-
To write a letter of complaint
Questão 6
Questão
Which tool is best used to duplicate information from cell to cell?
Responda
-
Autosum
-
Fill Handle
-
Filter
Questão 7
Questão
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Responda
-
Because Mr Obhan can use bar charts
-
Because they don't require you to enter any formula.
-
Because you do not need to enter any data
-
Because the data is presented in a more visual way.
Questão 8
Questão
Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
Responda
-
Resize a cell to fit the text inside
-
Put a background on a cell containing text
-
Put a border around a cell containing text
-
Put text that is longer than the width of the cell on more than one line within the same cell
Questão 9
Questão
The software can help guide us through the process of creating a chart. This is called a...?
Responda
-
Teacher
-
Wizard
-
Help
-
Magician
Questão 10
Questão
What term describes changing the horizontal or vertical position of text?
Responda
-
Font
-
Alignment
-
Format
Questão 11
Questão
Getting cells to change colour automatically based on the contents of the cell is called...?
Responda
-
Content formating
-
Conditional formatting
-
Cell formatting
Questão 12
Questão
Which function would we use to calculate the total of a column or a row?
Responda
-
SUM
-
ADD
-
PLUS
Questão 13
Questão
When we select a group of cells together to use in a formula this is called a..?
Responda
-
Block
-
Sheet
-
Range
Questão 14
Questão
What function do we use to join a group of cells together to make a larger cell ?
Responda
-
Merge
-
Verge
-
Combine
Questão 15
Questão
Spreadsheets can (tick all that apply)...?
Responda
-
Complete mathmatical calculations
-
Present data in a visual way
-
Produce large written documents
-
Search large amounts of data
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.