Year 11
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 implement a spreadsheet which represents seating for the live event of Rock Star Challenge. The spreadsheet includes different seat prices for adults, students, and over 60s. We will use a drop-down list to select seats, and formulae will be used to calculate the price.
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.
Write a formula for cell D9.
=B9xC9
B9*C9
B9xC9
Q2.
Write a formula for cell D24.
=D8:D22
=D8:D24
=D8*D22
Q3.
Write a formula for cell J8.
=H8*G8
=I8*H8
=J6*J7
Q4.
Write a formula for cell J15.
=SUM(G8:G15)
=SUM(G8:J13)
=SUM(I8:G13)
3 Questions
Q1.
a. Using 1 word, what do you think the formula in cell F3 is doing?
Averaging
Summing
Q2.
b. What do you think the formula in cell F3 looks like? Circle your answer
=COUNTA(C4:C15)
=COUNTIF(C4:C15,">0")
Q3.
For each employee, their point on the payscale is entered (column C) and a lookup formula in column D returns their actual salary. What two advantages are there to using a lookup here?
Increases user input errors.