Lesson 1 of 5
  • Year 11
Lesson 1 of 5
  • Year 11

Spreadsheet warm-up

These resources will be removed by the end of the Spring Term 2026.

Start using our brand new teaching resources now. Designed by teachers and subject experts, with real classrooms in mind.

The older resources below were created for lockdown learning during the pandemic and are not designed for classroom teaching.

Lesson details

Key learning points

  1. 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.

An image in a quiz
Correct answer: =B9*C9
=B9xC9
B9*C9
B9xC9

Q2.
Write a formula for cell D24.

=D8:D22
=D8:D24
=D8*D22
Correct answer: =SUM(D8:D22)

Q3.
Write a formula for cell J8.

=H8*G8
Correct answer: =I8*G8
=I8*H8
=J6*J7

Q4.
Write a formula for cell J15.

=SUM(G8:G15)
=SUM(G8:J13)
=SUM(I8:G13)
Correct answer: =SUM(J8:J13)