Spreadsheet modelling

Computing

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

Which of the following is NOT a key component of a spreadsheet model?

Match the keywords to their correct definitions:

What is the purpose of spreadsheet formatting?

Type in the formula to subtract B5 from J2:

Type in the function to add cell A1 to A5.

Which symbol is used for addition in calculations?

Which symbol is used for division in calculations?

a set of instructions to perform a calculation

What is the purpose of tables in software?

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

Spreadsheet modelling

Lesson outcome

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