Durgesh Verma
7 years ago

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.

This Question Belongs to User Ask Question >> Miscellaneous

Join The Discussion

Related User Ask Questions