Have an account?
Skip to Content
Build your own quiz
Suggestions for you
15 questions
Show Answers
See Preview
- 1. Multiple Choice
What is the space within the black border?
a cell
a box
a variable
a column
- 2. Multiple Choice
When you type a formula, what symbol must it start with?
!
*
+
=
- 3. Multiple Choice
In a cell reference, for example B2, what does the letter refer to?
The row the cell is in.
The worksheet the cell is in
The column the cell is in.
The spreadsheet the cell is in.
- 4. Multiple Choice
What would a spreadsheet be best used for?
Writing a letter
making a presentation
keeping track of your savings or money
searching for information
- 5. Multiple Choice
In a cell reference, such as B2, what does the number stand for?
the column the cell is in
the worksheet the cell is in
the row the cell is in
the value of the cell
- 6. Multiple Choice
Mathematical calculations in a spreadsheet are called:
words
values
formulas
labels
- 7. Multiple Choice
What function will add up all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
- 8. Multiple Choice
Which of the following is an example of a multiplication formula?
A-B
=C10-B9
14 x 10 = 140
=B2*B3
- 9. Multiple Choice
Which of the following cannot be used to create a spreadsheet?
Microsoft Excel
Google Sheets
Google Docs
Open Office Calc
- 10. Multiple Choice
Which of the following is an example of an addition formula?
=B4+D7
2+3+6=11
F3*G7
=B9/B6
- 11. Multiple Choice
What kind of a chart is this?
a pie chart
a bar chart
a cake chart
a line graph
- 12. Multiple Choice
What kind of a chart is this?
A line graph
A bar chart
A pie chart
Scatter Chart
- 13. Multiple Choice
What does CTRL Z do?
Cut
Undo
Paste
Copy
- 14. Multiple Choice
Tatsuo Horiuchi uses spreadsheets to create art. Which of the examples below do you think is a real use of a spreadsheet?
Create a full length role playing game.
Convert a photo into a spreadsheet
Create a sudoku
All three!
- 15. Multiple Choice
What function will calculate the AVERAGE of all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
- Answer choicesTagsAnswer choicesTags