2.2 - AVERAGE
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What is the syntax for the AVERAGE function?
💡 Hint: Think about how functions are usually written in spreadsheets.
What would =AVERAGE(C1:C5) calculate?
💡 Hint: Remember, 'C1:C5' refers to all cells in that range.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the AVERAGE function calculate?
💡 Hint: Think about what 'average' usually means in statistics.
True or False: The AVERAGE function considers blank cells in calculations.
💡 Hint: Consider how averages are calculated only from the numbers present.
1 more question available
Challenge Problems
Push your limits with advanced challenges
You have the following numbers in a dataset: 5, 10, 15, 20, 1, and 50. Calculate the average, discuss how the number 50 affects the average.
💡 Hint: Consider what happens when you remove outliers.
In a survey, the following ratings were received: 1, 4, 4, 4, 5, 2, 3. What does the average indicate about satisfaction levels?
💡 Hint: Sum all scores and divide by how many were given.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.