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.

Loading...

3 Questions

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

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?
An image in a quiz
No
Correct answer: Yes
Q5.
In the image shown has the last column made use of an auto fill?
An image in a quiz
Correct answer: No
Yes