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

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In PowerPoint, to hide a slide during a presentation without deleting it, right-click and select:
A. Hide Slide
B. Disable Slide
C. Exclude Slide
D. Skip Slide

Correct Answer: Option A


Explanation:
The option is 'Hide Slide'. Hidden slides are not shown in slide show unless navigated to manually.

This question belongs to: Computer Microsoft Office
Question #2
In Access, which of the following is used to create a query that asks for user input?
A. Crosstab Query
B. Select Query
C. Parameter Query
D. Action Query

Correct Answer: Option C


Explanation:
Parameter queries prompt for input.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following view layouts in MS PowerPoint is specifically optimized for reviewing presentation slides sequentially as a continuous reading text book script?
A. Master Designer interface
B. Notes Page structural mode
C. Slide Show view
D. Reading View

Correct Answer: Option D


Explanation:
Reading View runs the presentation inside a resizable system window with basic control buttons, making it ideal for checking layout flows without entering a full-screen projection.

This question belongs to: Computer Microsoft Office