Question

In Microsoft Excel, what will be the output of \[ \texttt{=COUNT(A1:A5)} \] if the range A1:A5 contains three numeric values and two text values?

• A. 5
• B. 4
• C. 3
• D. 2

Hint:

Remember the difference:
• COUNT $\rightarrow$ Counts only numbers.
• COUNTA $\rightarrow$ Counts all non-empty cells.
• COUNTBLANK $\rightarrow$ Counts blank cells.
• COUNTIF $\rightarrow$ Counts cells meeting a condition.

Answer 1

The Correct Option is C

Concept: The COUNT() function in Microsoft Excel counts only the cells that contain numeric values. It ignores text, blank cells, logical values and other non-numeric data. Its syntax is: \[ \boxed{\texttt{COUNT(value1, value2, \ldots)}} \] or \[ \boxed{\texttt{COUNT(A1:A5)}} \]

Step 1: Understand the COUNT function.
The COUNT function counts only:
• Numbers
• Dates and times (stored as numbers) It does not count:
• Text values
• Blank cells
• Error values

Step 2: Apply the function to the given data.
Given:
• Numeric values = 3
• Text values = 2 Since COUNT counts only numbers, \[ \boxed{\texttt{COUNT(A1:A5)=3}} \]

Step 3: Analyse the options.

• 5 -- Incorrect (includes text).
• 4 -- Incorrect.
• 3 -- Correct.
• 2 -- Incorrect.

Step 4: Know related Excel functions.
{|l|l|} Function & Purpose
COUNT & Counts only numeric cells
COUNTA & Counts all non-empty cells
COUNTBLANK & Counts blank cells
COUNTIF & Counts cells satisfying a condition

Step 5: Final conclusion.
Therefore, the output of \[ \texttt{=COUNT(A1:A5)} \] is \[ \boxed{3} \]