Lesson details

Key learning points

  1. In this lesson, we will learn how to create accurate and useful charts based on generated data. Charts are often used to quickly give information and to help visualise sometimes quite complex data, but it is important to select the right chart for the data and to implement the chart accurately.


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.


3 Questions

Conditional formatting could have been used here on Column G, how would it be used?
An image in a quiz
Correct answer: To apply a specific colour depending on the average.
To change the average to a percentage.
What do you think the formula in column G is doing?
Correct answer: It is calculating an average of the marks achieved in the four exams.
It is calculating the total of the marks achieved in the four exams.
It is counting the marks achieved in the four exams.
What do you think the formula looks like?
Correct answer: =AVERAGE(C4:F4)

3 Questions

What is an advantages of representing data as a chart?
It can oversimplify data.
Correct answer: It is easier to interpret.
Correct answer: It is more visual.
What type of chart would be ideal for representing percentage or proportional data?
Bar chart
Line chart
Correct answer: Pie chart
What is a macro in spreadsheets?
A type of chart.
Correct answer: Something you can record to automate tasks.