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.
This quiz will help you to check any previous learning on this topic, and re-cap anything you may have forgotten. Once you have completed this, click ‘Close Quiz’ and then ‘Next’ below.
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.
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.