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. COUNTBLANK()

B. COUNT()

C. COUNTIF()

D. COUNTA()

Answer: Option D

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 Access, to create a relationship between two tables, you typically use:

A. External Data -> Link Tables

B. Create -> Table Relationships

C. Design -> Relationships

D. Database Tools -> Relationships

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Relationships are managed under Database Tools tab.

This question belongs to: Computer Microsoft Office

Question #2

To close a presentation in PowerPoint, press:

A. Ctrl + W

B. Alt + F4

C. Both A and B

D. Ctrl + F4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+W or Ctrl+F4 closes the active presentation window. Alt+F4 exits PowerPoint.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which of the following is NOT a field data type?

A. Memo

B. Long Text

C. Lookup

D. Calculated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Lookup is not a data type; it's a field property (using Lookup Wizard). Data types include Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs