Starter quiz
- Which tool is used to organise data in ascending or descending order in a spreadsheet?
- sort ✓
- filter
- freeze panes
- merge cells
-
- Which function would you use to count the number of non-blank cells in a range?
- COUNTBLANK
- COUNTA ✓
- ISNOTBLANK
- COUNTALL
-
- What does the function =IF(A1>10, "Yes", "No") do?
- 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
- deletes values in A1 less than 10
-
- What does the function =MIN(A1:A10) do?
- finds the smallest number in the group of cells A1 to A10 ✓
- adds all the numbers in A1 to A10
- counts how many numbers are in A1 to A10
- finds the largest number in A1 to A10
-
- Write the formula you would use to multiply the value in A1 by the value in B1.
- '=A1*B1' ✓
- The function used to add a group of numbers together is = ______ (A1:A10).
- 'SUM' ✓
Exit quiz
- What is the purpose of conditional formatting?
- to highlight cells based on specific criteria ✓
- to sort and filter data automatically
- to validate data entry rules
- to protect cells from being edited
-
- Which of these is an example of conditional formatting?
- highlighting all cells with values greater than 10 ✓
- changing the colour of a cell manually
- adding a border to all cells
- changing the font colour of all cells which contain the text 'Yes" ✓
-
- Which of these rules can be applied with conditional formatting?
- highlight cells equal to "Pass"
- change font colour for values less than 50
- create a colour scale for numbers in a range
- all of the above ✓
-
- Match the term to the definition.
- SUM⇔adds a group of numbers together ✓
- MIN⇔finds the smallest number in a range ✓
- MAX⇔finds the largest number in a range ✓
- conditional formatting⇔highlights cells based on their values ✓
- filter⇔displays only rows that meet certain criteria ✓
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- Conditional formatting applies a style or format to a cell based on whether a cell matches a certain criteria.
- Conditional formatting can be applied to specific data in a range of cells.
- Conditional formatting can be used to highlight or pick out key pieces of data.
- Spreadsheet tools can be combined to analyse and present data.
Common misconception
Pupils may think that conditional formatting can only be used to add background colour to a cell.
Conditional formatting can be used to apply a range of formatting a cell including the text of the cell itself.
Keywords
Conditional formatting - applies a style or format to a cell based on whether a cell matches a certain criteria
+