No student devices needed. Know more
20 questions
What are the individual rectangles on a worksheet called?
Rows
Columns
Cells
Formulae
A vertical line of cells in a spreadsheet is a what?
Row
Column
A horizontal line of cells in a spreadsheet is a what?
Row
Column
How are columns labelled on a worksheet?
Letters
Numbers
How are rows labelled on a worksheet?
Letters
Numbers
If you wanted to change the colour of the text inside a cell, which tool would you use?
Text colour
Fill colour
Borders
Bold
If you wanted one cell or a number of cells to stand out from the rest which tool could you use?
Bold
Fill Colour
Currency
Borders
If you wanted to change the size of the text inside a cell which tool would you use?
Cell width
Cell height
Text colour
Font size
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What do all formulae start with in a spreadsheet?
+
/
*
=
Which mathematical operator (symbol) would you use if you are adding the values in cells together?
/
-
+
=
Which mathematical operator (symbol) would you use to divide the values in two cells?
/
-
*
=
Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?
/
-
*
=
Which mathematical operator (symbol) would you use to multiply the values in two cells together?
/
-
*
=
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MIN
MAX
AVERAGE
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
Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta
£1.25 times 12
C5*D5
=C5*D5
Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Walkers salt and vinegar.
£0.65 times 23
C10 * D10
=C10 * D10
Explore all questions with a free account