WorksheetsSpreadsheets Y8 L5 starter
Total questions: 9
Worksheet time: 5mins
What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?
=
/
*
+
Name a function that tells you the:
Maximum value
MIN
MAX
SUM
DIV
Name a function that tells you the:
Minimum value
MIN
MAX
SUM
COUNT
Name a function that tells you the:
Number of non-blank cells
COUNTA
MIN
AVG
DIV
Show two ways you can add values together in a spreadsheet
Formula with plus
= +
SUM Function
ADD Function
Give the cell references for each of the following ranges:
The first ten cells of column B
B1:B10
1B:10B
B1-B10
Give the cell references for each of the following ranges:
The cells in rows 15–20 in column A
A15:A20
15A:20A
A15-A20
Give the cell references for each of the following ranges:
The cells in rows 15-20 in column A, B and C
A15:C20
A15-C20
15C:20A
Give the cell references for each of the following ranges:
All of the cells of column A from row 2 to the end
A2:A
A2:END
A2:ALL
