Spreadsheet formulas

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

something that performs calculations in a spreadsheet

Which operator is used for division in a spreadsheet formula?

Write the formula you would use to add a value in cell A1 to a value in cell B1.

The formula is copied and the cell references are adjusted.

What happens when you replicate a formula in a spreadsheet?

Find the small black cross in the bottom right corner of the cell.

a line of data that runs from left to right

a group of data that runs from top to bottom

It clarify what the data entered represents

Why is data formatting used in a spreadsheet?

Lesson video

File you will need for this lesson