WorksheetsSpreadsheets L4
Total questions: 15
Worksheet time: 8mins
What makes cells change in appearance?
Formula
Formatting
Function
Forgotten
What makes a simple calculation?
Formula
Formatting
Function
Forgotten
What makes a complex calculation like an average?
Formula
Formatting
Function
Forgotten
Which of these is NOT a formatting tool?
Background colour
Borders
Fonts
SUM
What does absolute referencing mean?
Cell references always have a letter and a number
Cell references move when you drag down
Cell references are stuck so they don't move when you drag down
Changing the font and colour of a cell
What will you see when a cell reference is "stuck"?
£
$
%
&
Which of these is NOT a graph in a spreadsheet?
Bar chart
Line graph
Pie chart
Tally chart
Which formula will MULTIPLY cells A2 and B2?
=A2*B2
A2+B2
=A2+B2
A2*B2
Which formula will ADD cells A2 and B2?
=A2*B2
A2+B2
=A2+B2
A2*B2
What do formulas always start with?
(a)
How can you re-order data in a spreadsheet?
Sort
Filter
Save
Cell
How can you hide data in a spreadsheet?
Sort
Filter
Save
Cell
How can you un-hide filtered data?
Delete the top row
Close and open the spreadsheet again
Filter and "Select all"
Sort it in a different order
What does "Conditional Formatting" mean?
Changing the background and borders
Changing the font and text colour
Changing how some cells look based on a rule
Hiding some data in the spreadsheet
What kind of job will NOT need a spreadsheet?
Scientist
Manager
Self-employed
Waiter
