Lesson details

Key learning points

  1. 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
Correct answer: Percent
Time
Q2.
Which format is best for the data held in a column with the data heading Number of items sold?
Currency
Date
Correct answer: Number
Q3.
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
£3.20
Apples
Correct answer: Cost
Correct answer: Item
Q4.
Which number format has been applied to this piece of data? 12:05:00
Currency
Date
Correct answer: Duration
Italics

4 Questions

Q1.
What does this operator mean in a spreadsheet / ?
Add
Correct answer: Divide
Multiply
Q2.
What does this operator mean in a spreadsheet * ?
Add
Correct answer: Multiply
Subtract
Q3.
Give the cell reference of the colored cell
An image in a quiz
A1
A2
B1
Correct answer: B2
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?
An image in a quiz
A1
A2
Correct answer: B2