Which function in excel tells how many numeric entries are there?
A. Num
B. Count
C. Sum
D. Chknum
Answer: Option B
Solution (By Examveda Team)
In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells.COUNT Function:
The COUNT function counts the number of cells that contain numeric values within a specified range. For example: =COUNT(A1:A10)
This formula will return the number of cells containing numbers in the range A1 through A10.
Option A: Num
This is not a valid Excel function.
Option C: Sum
The SUM function adds all the numeric values in a specified range, but it does not count them. For example: =SUM(A1:A10)
This formula will return the total sum of the numbers in the range A1 through A10.
Option D: Chknum
This is not a valid Excel function.
Therefore, the correct answer is Option B: Count as it accurately counts the number of numeric entries in a specified range.

Join The Discussion