Become a data master!
In this lesson, you will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data, you will be introduced to four functions: SUM, MAX, MIN, and COUNTA. Functions allow you to very quickly calculate results. The functions covered in this lesson are used to calculate totals, find the maximum and minimum values in a range, and count populated (i.e. non-blank) cells.
Video
Click on the play button to start the video. If your teacher asks you to pause the video and look at the worksheet you should:
- Click "Close Video"
- Click "Next" to view the activity
Your video will re-appear on the next page, and will stay paused in the right place.
Worksheet
These slides will take you through some tasks for the lesson. If you need to re-play the video, click the ‘Resume Video’ icon. Once you have finished all the tasks, click ‘Next’ below.
Final Quiz
This quiz is a great way for you to test your learning from this lesson.
If you would like to re-cap any of the lesson, or repeat any exercise, click ‘Back’ below.