Lesson details

Key learning points

  1. In this lesson, we will plan and calculate the cost of an event using a spreadsheet. We will use a list to choose what we would like to include in our event, and use our spreadsheet to answer questions on the data we have selected.


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.


3 Questions

Which of these statements are true about spreadsheets? (Tick all that apply)
Calculations can be used on any data type in a spreadsheet
Correct answer: Data can be calculated using different operations within the spreadsheet
Correct answer: When using formulas with cell references; changing one cell can change another
Using the spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?
An image in a quiz
Correct answer: =B3*C3
3) What does this SUM function calculate?=SUM(A1:A4)
A data heading
The total cost of items
The total of A1 and A4
Correct answer: The total of A1, A2, A3 and A4

3 Questions

Why are data headings important? (Tick 2 boxes)
They allow us to experiment with formatting.
Correct answer: They enable us to keep the data organised.
Correct answer: They help for effective use of formula.
They look attractive on a spreadsheet.
Why should data be organised? (Tick 2 boxes)
Correct answer: It is easier to perform calculations using the data.
Correct answer: It makes easier to read and understand data.
It stifles creativity.
Makes the spreadsheet attractive.
What calculation in your formula will you use to find C2-Total budget?
An image in a quiz
Correct answer: A2*B2