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?

This lesson will be removed by end of Summer Term 2025.

Using formulas in a spreadsheet

Lesson outcome

This lesson will be removed by end of Summer Term 2025.