a predefined formula that performs a calculation

a function that looks for a value in one column and finds matching information from the same row in another column

a function in a spreadsheet that checks if something is True or False

Lookup and reference functions

Computing

Spreadsheet modelling

Formulas in a spreadsheet model

Formatting in a spreadsheet model

Data validation in a spreadsheet model

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

to retrieve data from another sheet based on a matching value

What is the purpose of the VLOOKUP function?

Write the formula to retrieve data from the second column of the range T1:W12, from a sheet called LOOKUP sheet, matching the value in cell A1.

checks a condition and returns outcomes based on whether it is True or False

What does the IF function do in a spreadsheet?

The IF function can check a condition and return different outcomes.

The IF function can display custom messages for True and False results.

The IF function can only return the words "True" or "False".

The IF function can be used to provide user feedback.

Which of the following statements about the IF function is incorrect?

Write the formula that checks if the value in cell A1 is less than 50 and returns "Low" if True or "High" if False.

to apply formatting based on specific rules

What is the purpose of conditional formatting in spreadsheets?

by limiting the type of data that can be entered

How does data validation help prevent mistakes?

the rules that decide what data is allowed

Arrange the steps to set up data validation in the correct order:

How can data validation improve consistency in spreadsheets?

a tool that controls what kind of data can be entered into a cell

a warning shown when data doesn’t meet the criteria

Match the terms with their correct descriptions:

Lookup and reference functions

Lesson outcome