Spreadsheets L4

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?