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

Applying conditional formatting to data

Computing

Formatting data in a spreadsheet

Spreadsheet calculations

Collecting data for a purpose

Analysing and visualising data

Sorting and searching data

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Data modelling

to highlight cells based on specific criteria

What is the purpose of conditional formatting?

highlighting all cells with values greater than 10

changing the font colour of all cells which contain the text 'Yes"

Which of these is an example of conditional formatting?

change font colour for values less than 50

create a colour scale for numbers in a range

Which of these rules can be applied with conditional formatting?

displays only rows that meet certain criteria

Which tool is used to organise data in ascending or descending order in a spreadsheet?

Which function would you use to count the number of non-blank cells in a range?

counts the number of cells greater than 10 in the range A1

checks if the value in A1 is greater than 10 and returns "Yes" or "No"

sorts values greater than 10 into a new range

What does the function =IF(A1>10, "Yes", "No") do?

finds the smallest number in the group of cells A1 to A10

Write the formula you would use to multiply the value in A1 by the value in B1.

The function used to add a group of numbers together is = {{}} (A1:A10).

Lesson video

Files you will need for this lesson