Microsoft Excel 2021365 - Beginner to Advanced - Counting Values and Blanks

The video tutorial covers essential Excel functions for counting items in a range. It begins with an introduction to the Count function, explaining its use for counting numeric values. The tutorial then demonstrates how to use the CountA function to count all non-empty cells and the CountBlank function to count only blank cells. Additionally, it shows how to use the Functions dialog and AutoSum feature for counting, highlighting common pitfalls and solutions.

What is the primary purpose of the COUNT function in Excel?

• To count all cells in a range

• To count only numeric cells in a range

• To count only text cells in a range

• To count blank cells in a range

Why did the COUNT function return 0 when applied to the student names?

• Because the COUNT function only counts numeric values

• Because the names were not in alphabetical order

• Because the names were in a different worksheet

• Because the list was too short

Which function should you use to count all non-empty cells in a range?

• COUNT

• COUNTA

• SUM

• COUNTBLANK

What happens when you delete a name from the list while using the COUNTA function?

• The count becomes zero

• The count decreases by one

• The count increases by one

• The count remains the same

Which function would you use to count only the blank cells in a range?

• COUNTA

• COUNT

• SUM

• COUNTBLANK

What is the result of using COUNTBLANK on a range with one blank cell?

• 0

• 1

• The total number of cells

• The total number of non-empty cells

Which function would you use to count numeric values in a range?

• SUM

• COUNTBLANK

• COUNTA

• COUNT