Year 7

Year 7

# Quick calculations

## Slide deck

Download slide deck

## Lesson details

### Key learning points

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

## Video

Share with pupils

Loading...

## Worksheet

Download worksheet
Share with pupils

## Starter quiz

Download starter quiz
Share with pupils

### 3 Questions

Q1.
Can you name the range of cells in this image?
A1:A7
Correct answer: A2:A6
A6:A3
Q2.
Can you name the range of cells in this image?
A4:C8
Correct answer: A5:C7
B5:C7
C7:A5
Q3.
What is selected in the image?
Cell
Column
Correct answer: Row

## Exit quiz

Download exit quiz
Share with pupils

### 5 Questions

Q1.
In a Spreadsheet how would you write a formula for 4 x 3?
Correct answer: =4*3
=4/3
4*3
Q2.
In a Spreadsheet how would you write a formula for 179 + 56?
Correct answer: =179+56
179+56
56+179
Q3.
In a Spreadsheet how would you write a formula for 764 divided by 4?
=764*4
Correct answer: =764/4
=764%4
Q4.
In the image shown has a auto fill been used for column D?
No
Correct answer: Yes
Q5.
In the image shown has the last column made use of an auto fill?
Correct answer: No
Yes