British English CC

Using formulas in a spreadsheet

Computing

This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.

Introduction to spreadsheets

a collection of cells that are next to each other

What does a range of cells refer to in a spreadsheet?

How would you type in the range of cells that include A1, A2, A3, B1, B2 and B3.

Which of the following is NOT a benefit of using spreadsheet functions?

What should you do if a pre-built function exists for your calculation needs?

How do you calculate the average of values in cells A1 to A5 using a spreadsheet function?

A mathematical expression that calculates a value.

An operation that performs calculations on a range of data.

What is the main purpose of using a table to organise data?

What does 'replicate' mean in the context of spreadsheets?

What is a rectangular box in a spreadsheet called?

What is used to perform calculations in a spreadsheet?

Introduction

What will you need for this lesson?

Are you ready to learn?

File you will need for this lesson

Equipment

Worksheet