Year 7
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- In this lesson, we will introduce three more functions "COUNTIF, AVERAGE, and IF" and to how they can sort and filter a spreadsheet. We will work on a larger data set to get a feel for analysing real-world data using spreadsheets.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
6 Questions
Q1.
Which of these is used to visualise information as a picture?
Apple chart
Circle chart
Pizza chart
Q2.
Which of these would you use to add up a range of numbers?
ADD
PLUS
TOTAL
Q3.
You use the MAX function to find:
The first value
The smallest value
The total
Q4.
What function would you use to find the smallest value?
COUNTA
LEAST
MAX
Q5.
What does the COUNTA function tell you?
The average
The largest value
The number of A's
Q6.
Which one of these can data be analysed by?
Blocks
Picture
5 Questions
Q1.
How is data sorted in a spreadsheet?
B-C or Z-A
Only A-Z
Q2.
What does filtering in a spreadsheet allow you to do?
Filtering allows you to add data
Filtering allows you to delete specific data
Q3.
Which AVERAGE formula is correct?
=AVERAGE(D:D9)
AVERAGE(D4:D9)
Q4.
What does the COUNTIF formula do?
Counts the column
Counts the rows
Q5.
Which is the correct IF formula?
=IF( “Well Done”, “Try again” D4=3,)
IF(D4=3, “Well Done”, “Try again”)