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

Question

Share Report Error

In Excel, which function is used to count the number of blank cells in a range?

A. COUNT

B. COUNTA

C. COUNTIF

D. COUNTBLANK

Answer: Option D

Solution (By JKSSB Mock Tests)

COUNTBLANK counts 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

Share Report

In PowerPoint, the 'Notes Page' includes:

A. A miniature of the slide and space for speaker notes

B. Slide thumbnails and transitions

C. Only speaker notes

D. Audience handouts

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Notes Page shows a small slide image and a notes area.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, to import data from another Access database, use:

A. Database Tools -> Import

B. External Data -> Access

C. File -> Open

D. Create -> Import Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
External Data tab has import from Access.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?

A. #REF!

B. #DIV/0!

C. #VALUE!

D. #NUM!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs