In MS Excel, what function can you use to count the number of empty or unpopulated cells within a specified range? MCQ with Answer and Explanation

In MS Excel, what function can you use to count the number of empty or unpopulated cells within a specified range?
A. COUNTIF
B. COUNT
C. COUNTBLANK
D. COUNTA
Answer: Option C
Solution (By JKSSB Mock Tests)
COUNTBLANK counts empty cells within a specified cell range.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
To open a new document in MS Word, press:
A. Ctrl + Alt + N
B. Ctrl + S
C. Ctrl + O
D. Ctrl + N

Correct Answer: Option D


Explanation:
Ctrl+N new document.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, which option allows you to apply a custom color to all slide backgrounds at once?
A. View -> Slide Master -> Background Styles
B. Design -> Format Background -> Apply to All
C. Both A and B
D. Home -> Fill Color

Correct Answer: Option C


Explanation:
Both methods can set background for all slides: Slide Master or Format Background with Apply to All.

This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to open the 'Go To' dialog box in MS Excel?
A. F5
B. Ctrl + G
C. Ctrl + F
D. Ctrl + H

Correct Answer: Option A


Explanation:
F5 opens the Go To dialog in Excel. Ctrl+G also opens Go To (same as F5). But both are valid. However, in many exams, F5 is the standard. I'll put F5 as correct. But the question asks for shortcut key, and both are possible. To avoid ambiguity, I'll change the question to 'Which key opens the Go To dialog in Excel?' and correct answer F5. But since both, I'll pick F5 as default.

This question belongs to: Computer Microsoft Office