Lesson details

Key learning points

  1. In this lesson, we will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data. We will be introduced to four functions: SUM, MAX, MIN, and COUNTA.

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...

5 Questions

Q1.
What is the meaning of a formula?
Correct answer: A formula is a calculation, which starts with a = sign.
A formula is when different chemicals are placed together to create a reaction.
A formula never starts with a = sign and involves only numbers with no symbols.
Q2.
What is Data?
Data can be anything.
Correct answer: Data is facts and figures.
Data is just symbols.
Q3.
What is the difference between data and information?
When data is converted into information so that only text words are used.
Correct answer: When data is organised so that it has some meaning to it, it then becomes information.
When you use charts to show only information about females in a class.
Q4.
Which one of these is an example of a primary source?
Correct answer: Interview
Newspaper
Radio show
Q5.
What is a secondary source?
Correct answer: A secondary source is a source which you have found and may decide to use.
A secondary source is the same as a primary source, except it looks prettier, like a chart.
A secondary source is when you decide to carry out a survey.

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