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. Only blank cells

B. Only text cells

C. Only numeric cells

D. All non-empty cells

Answer: Option D

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

Which file format is used for a macro-enabled Word document?

A. .docx

B. .doc

C. .dotm

D. .docm

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.docm is macro-enabled document. .docx without macros, .dotm macro-enabled template.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, to hide the Ribbon, you can press:

A. F1

B. Alt + F1

C. Ctrl + Shift + F1

D. Ctrl + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F1 collapses/expands the Ribbon.

This question belongs to: Computer Microsoft Office

Question #3

Which transition or animation effect property in MS PowerPoint allows an animation to start at the exact same time as the previous animation item?

A. With Previous

B. After Previous

C. Trigger

D. On Click

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'With Previous' setting starts the selected animation effect simultaneously with the animation immediately preceding it on the slide timeline.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs