NEW
Font size
WorksheetsSpreadsheets
Total questions: 15
Worksheet time: 8mins
What is the space within the black border?
a cell
a box
a variable
a column
When you type a formula, what symbol must it start with?
!
*
+
=
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.
What would a spreadsheet be best used for?
Writing a letter
making a presentation
keeping track of your savings or money
searching for information
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
Mathematical calculations in a spreadsheet are called:
words
values
formulas
labels
What function will add up all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
Which of the following is an example of a multiplication formula?
A-B
=C10-B9
14 x 10 = 140
=B2*B3
Which of the following cannot be used to create a spreadsheet?
Microsoft Excel
Google Sheets
Google Docs
Open Office Calc
Which of the following is an example of an addition formula?
=B4+D7
2+3+6=11
F3*G7
=B9/B6
What kind of a chart is this?
a pie chart
a bar chart
a cake chart
a line graph
What kind of a chart is this?
A line graph
A bar chart
A pie chart
Scatter Chart
What does CTRL Z do?
Cut
Undo
Paste
Copy
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!
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)
