2 - Commonly Used Functions
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 does the SUM function do?
💡 Hint: Remember that it's about addition.
How do you write the AVERAGE function for cells B1 to B5?
💡 Hint: Think of how you find an average in any math problem.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the SUM function do?
💡 Hint: Think of it as addition in math.
True or False: MIN returns the largest value in a set.
💡 Hint: Consider what 'minimum' means.
2 more questions available
Challenge Problems
Push your limits with advanced challenges
You have a list of sales in cells A1 to A15. Write a formula using SUM to find the total sales.
💡 Hint: Remember, you're adding values together!
Using data in cells B1 to B10, write a formula using COUNT to find how many of these entries are numeric.
💡 Hint: This function is focused on counting numbers specifically.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.