# Quick calculations

## 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

## Worksheet

Share with pupils

## Starter quiz

Share with pupils

### 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

## Exit quiz

Share with pupils

### 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