In Excel, which function counts all cells that are not empty in a range? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function counts all cells that are not empty in a range?

A. COUNT()

B. COUNTIF()

C. COUNTA()

D. COUNTBLANK()

Answer: Option C

Solution (By JKSSB Mock Tests)

COUNTA counts non-empty cells. COUNT counts only numbers, COUNTBLANK 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

In MS Excel, what does the error message '#NULL!' typically indicate?

A. A cell contains an invalid division calculation

B. A required parameter in a formula is missing

C. A numeric value is outside of the expected bounds

D. A formula specifies an intersection of two cell ranges that do not intersect

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The #NULL! error appears when a space operator is used between two ranges that do not actually cross paths or intersect (e.g., =SUM(A1:A2 B1:B2)).

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which feature allows you to create a list of terms and their definitions at the end of a document?

A. Index

B. Glossary

C. Bibliography

D. Table of Contents

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An Index lists terms and their page numbers, but not definitions. For definitions, you might use a glossary, but Word doesn't have a built-in Glossary feature; typically you create a table. However, Index is for keywords. This question may be tricky. Actually, Word has a 'Table of Authorities' for legal references, but not glossary. I think the intended answer might be 'Table of Contents'? No. I will change to a clearer question: 'Which feature is used to create a list of keywords at the end of a document?' Answer: Index. So I'll replace with that.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, to insert a sound clip, which tab do you use?

A. Transitions

B. Animations

C. Design

D. Insert

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Audio is inserted via Insert tab -> Media group.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs