modifying the appearance of data in a spreadsheet

automatically break long text within a cell onto multiple lines

combining two or more adjacent cells into one larger cell

applies a style or format to a cell based on whether a cell matches a certain criteria

Formatting in a spreadsheet model

Computing

Spreadsheet modelling

Formulas 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

Match the spreadsheet actions to their outcomes:

Which number format would be most appropriate for displaying monetary values in a spreadsheet?

Arrange the steps to wrap text in a cell:

changing the font size of all cells manually

highlighting cells with values greater than 100 automatically

Which of the following is an example of conditional formatting?

to highlight specific data based on rules

What is the purpose of applying conditional formatting to a spreadsheet?

the formatting updates automatically if the value meets the condition

the formatting must be reapplied manually

the formatting is deleted and needs to be reapplied

the formatting changes the condition itself

What happens to conditional formatting when the value in a cell changes?

What does the term "replicate" mean in spreadsheets?

Which of the following is an example of an absolute reference?

the reference changes based on the new location

What happens when you drag the fill handle with a relative reference?

to ensure references adjust automatically

Why is it important to use absolute references in formulas?

What is the formula to divide the value in cell C1 by the value in D1, keeping the reference to D1 constant?

performs a specific calculation in a cell

a pre-built instruction for a specific task

adjusts automatically when copied to another cell

Match the terms to their correct descriptions:

This lesson was made for home learning during the pandemic.

Formatting in a spreadsheet model

Lesson outcome

This lesson was made for home learning during the pandemic.