Spreadsheet warm-up
Slide deck
Download slide deck
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.
Video
Share with pupils
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)