Which function would you use to count only numeric entries in a selected range?
2023
Which function would you use to count only numeric entries in a selected range?
Answer: D. COUNT — The correct answer is Option D: COUNT. In spreadsheet applications like Excel or Google Sheets, the COUNT function is specifically designed to count only the…
- A.
COUNTA
- B.
COUNTIF
- C.
COUNTBLANK
- D.
COUNT
Attempted by 116 students.
Show answer & explanation
Correct answer: D
The correct answer is Option D: COUNT. In spreadsheet applications like Excel or Google Sheets, the COUNT function is specifically designed to count only the cells that contain numeric values within a specified range, completely ignoring text, errors, or empty cells.
Loading lesson…