NEW
Font size
WorksheetsSpreadsheets Retrieval
Total questions: 19
Worksheet time: 10mins
What is the term used for each box in a spreadsheet?
Cell
Box
Field
Record
What is the term used for cells which appear going across the spreadsheet?
Column
Record
Field
Row
What is the term used for cells which appear going up and down the spreadsheet?
Field
Row
Column
Record
A cell can contain text, values and what else?
Currency
Percentages
Formulae
Dates
What symbol is used to multiply?
/
-
+
*
What symbol is used to divide?
*
+
/
-
How must a cell containing a formula start?
SUM
=
+
( )
What function is used to add more than 2 cells?
+
=
SUM
( )
How are columns labelled on a worksheet?
Letters
Numbers
How are rows labelled on a worksheet?
Letters
Numbers
What is the cell reference of the cell with value Coca-Cola inside?
A3
3A
C5
D7
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?
Item
Price
Number Sold
Total
What do people use spreadsheets for
For fun
To create presentations
To write letters
To store and organise information
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
What function was used to find the lowest grade?
average
sum
min
max
How can you quickly copy a formula down to multiple cells?
Manually type the formula in each cell.
Use the Fill Handle (small black square in the bottom right corner of the cell).
Use the Paste Special option.
Use the Data Validation tool.
What is the symbol used to indicate an absolute cell reference in a formula?
* (asterisk)
$ (dollar sign)
% (percent sign)
# (number sign)
