Starter quiz
- What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?
- '=' ✓
- Name the function that tells you the highest value in a range of cells.
- 'MAX' ✓
- Name the function that tells you the lowest value in a range of cells.
- 'MIN' ✓
- Name the function that tells you the number of non-blank cells.
- 'COUNTA' ✓
- Give the cell range for the first 10 cells of column B.
- 'B1:B10' ✓
- Give the cell range for all of the cells in column A.
- 'A:A' ✓
Exit quiz
- Applying a ______ to data arranges it into a different order.
- 'sort' ✓
- When a filter is applied to a data set the data that is filtered is removed permanently.
- True
- False ✓
- Match the function to its description.
- MIN⇔returns the lowest value in a range of cells ✓
- MAX⇔returns the highest value in a range of cells ✓
- SUM⇔returns the total value of a range of cells ✓
- COUNTA⇔returns the total number of non-empty cells in a range of cells ✓
- COUNTIF⇔returns the total number of cells that meet set criteria ✓
- IF⇔returns different things depending on a criterion ✓
- What is the function that adds up all the values in a selected range and then divides by how many items there are in the range?
- AVERAGE ✓
- SUM
- MIN
- MAX
-
Worksheet
Presentation
Video
Lesson Details
Key learning points
- Data can be sorted in ascending or descending order.
- Filters can be applied to hide data that is not needed for a purpose.
- A sort or filter can be applied to a data set to make it easier to analyse or visualise information.
- A function is a predefined formula in a spreadsheet that can help with calculations.
Common misconception
When a filter is applied to a data set the data that is filtered is removed permanently.
A filter can be applied to data to remove selected data from a data set. However, this data is not permanently removed, if the filter is taken off the data will still be there.
Keywords
Sort - arranging data into a meaningful order
Filter - given criteria used to show a subset of a data set
Function - a predefined formula that performs a calculation
+