2498748
Question 1
Question
Which of the following is capable of producing a spreadsheet Tick all that apply?
Answer
-
Google Docs
-
Microsoft Office Excel
-
Microsoft Office Word
Question 2
Question
What word is used to describe re-organising the order of data?
Answer
-
Search
-
Filter
-
Sort
Question 3
Question
In a cell reference, for example A1, what does the letter refer to?
Answer
-
The row the cell is in
-
The column the cell is in
-
The worksheet the cell is in
Question 4
Question
Formulae must always start with which symbol?
Answer
-
Equals
-
Add
-
Brackets
Question 5
Question
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Answer
-
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
Question 6
Question
Which tool is best used to duplicate information from cell to cell?
Answer
-
Autosum
-
Fill Handle
-
Filter
Question 7
Question
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Answer
-
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.
Question 8
Question
Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
Answer
-
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
Question 9
Question
The software can help guide us through the process of creating a chart. This is called a...?
Answer
-
Teacher
-
Wizard
-
Help
-
Magician
Question 10
Question
What term describes changing the horizontal or vertical position of text?
Answer
-
Font
-
Alignment
-
Format
Question 11
Question
Getting cells to change colour automatically based on the contents of the cell is called...?
Answer
-
Content formating
-
Conditional formatting
-
Cell formatting
Question 12
Question
Which function would we use to calculate the total of a column or a row?
Answer
-
SUM
-
ADD
-
PLUS
Question 13
Question
When we select a group of cells together to use in a formula this is called a..?
Answer
-
Block
-
Sheet
-
Range
Question 14
Question
What function do we use to join a group of cells together to make a larger cell ?
Answer
-
Merge
-
Verge
-
Combine
Question 15
Question
Spreadsheets can (tick all that apply)...?
Answer
-
Complete mathmatical calculations
-
Present data in a visual way
-
Produce large written documents
-
Search large amounts of data
Want to create your own Quizzes for free with GoConqr? Learn more.