In Excel, which function is used to count the number of cells that contain numbers in a range? MCQ with Answer and Explanation

In Excel, which function is used to count the number of cells that contain numbers in a range?
A. COUNTA
B. COUNT
C. COUNTBLANK
D. COUNTIF
Answer: Option B
Solution (By JKSSB Mock Tests)
COUNT counts only numeric cells. COUNTA counts non-empty, COUNTIF conditional, COUNTBLANK empty.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In Excel, which function returns the number of characters in a text string?
A. TEXT
B. LENGTH
C. LEN
D. CHAR

Correct Answer: Option C


Explanation:
The LEN function returns the number of characters in a text string. LENGTH is not a function, CHAR returns a character based on code, TEXT formats a value.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, to remove a hyperlink but keep the text, right-click and select:
A. Ctrl + Shift + F9
B. Remove Hyperlink
C. Edit Hyperlink -> Remove
D. Delete Link

Correct Answer: Option B


Explanation:
Right-click the hyperlink and choose Remove Hyperlink. Ctrl+Shift+F9 also removes hyperlink field codes.

This question belongs to: Computer Microsoft Office
Question #3
In MS PowerPoint, which option is used to change the order of slides?
A. All of the above
B. Slide Sorter View
C. Normal View
D. Outline View

Correct Answer: Option B


Explanation:
Slide Sorter View is specifically for rearranging slides, but you can also drag in Normal View or Outline. However, Slide Sorter is the primary view for reordering.

This question belongs to: Computer Microsoft Office