What's the formula?

Computing

What is a spreadsheet?

Modifying spreadsheets

Calculate and duplicate

Event planning

Presenting data

Spreadsheets

What does this operator mean in a spreadsheet  /  ?

What does this operator mean in a spreadsheet  *  ?

Give the cell reference of the colored cell

The Subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to change the value shown in D2?

Which format is best for the data held in a column with the data heading Discount?

Which format is best for the data held in a column with the data heading Number of items sold?

Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)

Which number format has been applied to this piece of data?  12:05:00

This lesson will be removed by the end of the Spring Term 2026.

What's the formula?

Lesson outcome

This lesson will be removed by the end of the Spring Term 2026.