Year 6
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- In this lesson, we will begin to use formulas to produce calculated data. We will learn that the type of data in a cell is important (e.g. numbers can be used in calculations whereas words cannot). Then we will create formulas to use in our spreadsheets using cell references
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
4 Questions
Q1.
Which format is best for the data held in a column with the data heading Discount?
Date
Time
Q2.
Which format is best for the data held in a column with the data heading Number of items sold?
Currency
Date
Q3.
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
£3.20
Apples
Q4.
Which number format has been applied to this piece of data? 12:05:00
Currency
Date
Italics
4 Questions
Q1.
What does this operator mean in a spreadsheet / ?
Add
Multiply
Q2.
What does this operator mean in a spreadsheet * ?
Add
Subtract
Q3.
Give the cell reference of the colored cell
A1
A2
B1
Q4.
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?
A1
A2