Practice Count (2.5) - Spreadsheet – Functions and Charts

Practise this section

9 questions

Flashcard drill
2 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the COUNT function do?
Show hintHide hint
Think about counting numbers in a list.
Question 2.
Write the formula for counting the numeric entries in cells A1 to A5.
Show hintHide hint
Remember the structure starts with '=' then the function name.
3Question 3.
What does the COUNT function return?
- The total number of cells
- The number of numeric cells
- The average of numbers
Show hintHide hint
Think about what it counts specifically.
4Question 4.
True or False: The COUNT function can count both numbers and text.
- True
- False
Show hintHide hint
Consider what kind of data it counts.
Question 5.
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?
Show hintHide hint
Consider using COUNTIFS to apply conditions.
Question 6.
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?
Show hintHide hint
Look for how many are sales figures only.

5 more questions in this section. Enroll free to practise them all.