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 revisit and develop KS3 spreadsheet skills. We will check our understanding of spreadsheet layout, and refamiliarise ourselves with formulae
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)