Year 7
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 practise entering text into cells of a spreadsheet and then learn how to perform calculations on the data using basic formulas and cell references. We will learn how to use the autofill tool to duplicate cells and continue a linear pattern.
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...
3 Questions
Q1.
Can you name the range of cells in this image?
A1:A7
A6:A3
Q2.
Can you name the range of cells in this image?
A4:C8
B5:C7
C7:A5
Q3.
What is selected in the image?
Cell
Column
5 Questions
Q1.
In a Spreadsheet how would you write a formula for 4 x 3?
=4/3
4*3
Q2.
In a Spreadsheet how would you write a formula for 179 + 56?
179+56
56+179
Q3.
In a Spreadsheet how would you write a formula for 764 divided by 4?
=764*4
=764%4
Q4.
In the image shown has a auto fill been used for column D?
No
Q5.
In the image shown has the last column made use of an auto fill?
Yes