2.5 - COUNT
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 COUNT function do?
💡 Hint: Think about counting numbers in a list.
Write the formula for counting the numeric entries in cells A1 to A5.
💡 Hint: Remember the structure starts with '=' then the function name.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the COUNT function return?
💡 Hint: Think about what it counts specifically.
True or False: The COUNT function can count both numbers and text.
💡 Hint: Consider what kind of data it counts.
1 more question available
Challenge Problems
Push your limits with advanced challenges
You have a dataset of student grades A1 to A50, with some blanks. You want to count how many students have submitted grades between 70 to 100. How would you find this?
💡 Hint: Consider using COUNTIFS to apply conditions.
In your sales data from B1 to B100, several cells are empty, and some contain text. How can you determine the total number of sales entries?
💡 Hint: Look for how many are sales figures only.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.