Lesson details

Key learning points

  1. 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
Correct answer: Pie chart
Pizza chart
Q2.
Which of these would you use to add up a range of numbers?
ADD
PLUS
Correct answer: SUM
TOTAL
Q3.
You use the MAX function to find:
The first value
Correct answer: The largest value
The smallest value
The total
Q4.
What function would you use to find the smallest value?
COUNTA
LEAST
MAX
Correct answer: MIN
Q5.
What does the COUNTA function tell you?
The average
The largest value
The number of A's
Correct answer: The number of non-blank cells
Q6.
Which one of these can data be analysed by?
Blocks
Correct answer: Chart
Picture

5 Questions

Q1.
How is data sorted in a spreadsheet?
Correct answer: A-Z or Z-A
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
Correct answer: Filtering allows you to find specific data
Q3.
Which AVERAGE formula is correct?
=AVERAGE(D:D9)
Correct answer: =AVERAGE(D4:D9)
AVERAGE(D4:D9)
Q4.
What does the COUNTIF formula do?
Correct answer: Counts how many of a certain item there are
Counts the column
Counts the rows
Q5.
Which is the correct IF formula?
=IF( “Well Done”, “Try again” D4=3,)
Correct answer: =IF(D4=3, “Well Done”, “Try again”)
IF(D4=3, “Well Done”, “Try again”)