a cell reference that changes when a formula is copied or replicated to another cell

a cell reference that remains constant no matter where it is copied or replicated

Formulas in a spreadsheet model

Computing

Spreadsheet modelling

Formatting in a spreadsheet model

Data validation in a spreadsheet model

Lookup and reference functions

Visualising data using charts in a spreadsheet

Improving a spreadsheet model

Spreadsheet project I

Spreadsheet project II

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions.

Spreadsheets

What can the fill handle in a spreadsheet be used for?

What happens to a relative reference when a formula is copied to another cell?

when the reference needs to change automatically

When should you use an absolute reference in a formula?

How do you indicate an absolute reference in a spreadsheet formula?

What formula would you use to divide the value in cell A3 by the value in cell B10, ensuring that the reference to cell B10 remains constant?

What is the purpose of spreadsheet formatting?

a ready-made instruction for a specific job

Type the calculation to add the values in cells A1 to A5. Make sure you use a function.

What formula would you use to multiply the values in cells B2 and B10?

Formulas in a spreadsheet model

Lesson outcome