In Excel, what does the COUNTA function count? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the COUNTA function count?

A. All non-empty cells

B. Only blank cells

C. Only numeric cells

D. Only text cells

Answer: Option A

Solution (By JKSSB Mock Tests)

COUNTA counts cells containing any type of data (numbers, text, errors, etc.), excluding 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 does the formula =SUM(A1:A10) do in MS Excel?

A. Returns the maximum value in the range

B. Counts the number of cells with numbers in A1:A10

C. Finds the average of numbers in A1:A10

D. Adds all numbers in cells A1 through A10

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The SUM function adds all numeric values in the specified range. It does not count, average, or find max.

This question belongs to: Computer Microsoft Office

Question #2

In Word, which of the following is used to protect a document with a password?

A. Home > Protect Document

B. Review > Protect Document

C. Insert > Protect Document

D. File > Info > Protect Document

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Protect Document is under File > Info.

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