Correct Answer:
D. Counts non-empty cells
The correct answer is Counts non-empty cells.
- Explanation: The COUNTA() function in Excel is designed to count the number of cells within a specified range that are not empty. This means it counts cells containing any type of data, whether it's numbers, text, logical values (TRUE/FALSE), or error values.
- Why other options are false:
- A (Counts cells having alphabets): COUNTA counts any non-empty cell, not specifically those with alphabets. To count cells with only alphabets, you would typically use a combination of functions like SUMPRODUCT and ISTEXT.
- B (Counts empty cells): The COUNTBLANK() function is used to count empty cells.
- C (Counts cells having numbers): The COUNT() function is specifically used to count cells that contain only numbers.