In Excel, which function counts the number of blank cells in a range? MCQ with Answer and Explanation

Question
In Excel, which function counts the number of blank cells in a range?
A. COUNTIF()
B. ISBLANK()
C. COUNTA()
D. COUNTBLANK()
Answer: Option D
Solution (By JKSSB Mock Tests)
COUNTBLANK(range) returns count of empty cells.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?
A. #REF!
B. #NULL!
C. #NAME?
D. #VALUE!
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.
This question belongs to: Computer Microsoft Office
Question #2
Which feature in MS Word tracks edits, deletions, insertions, and formatting adjustments made to a shared document by multiple collaborators?
A. Smart Lookup monitoring
B. AutoCorrect registry
C. Track Changes
D. Compare Documents wizard
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Track Changes logs every modification made to a document, allowing authors to review, accept, or reject specific edits later.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which of the following is used to create a table of contents based on heading styles?
A. References > Table of Contents
B. View > Table of Contents
C. Review > Table of Contents
D. Insert > Table of Contents
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Contents is under the References tab.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?