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

In Excel, what does the COUNTA function count?
A. Only numeric cells
B. Only blank cells
C. Only text cells
D. All non-empty cells
Answer: Option D
Solution (By JKExamLibrary)
COUNTA counts cells containing any type of data (numbers, text, errors, etc.), excluding empty cells.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
To select all the text in a document, press:
A. Ctrl + S
B. Ctrl + Alt + A
C. Ctrl + A
D. Ctrl + Shift + A

Correct Answer: Option C


Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the shortcut key to show/hide the ribbon in MS Office applications?
A. Alt + F1
B. Ctrl + F1
C. Ctrl + Shift + F1
D. Alt + F2

Correct Answer: Option B


Explanation:
Ctrl + F1 toggles the ribbon display in Office apps. Alt+F1 inserts a chart in Excel, others are not standard.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the function of the keyboard shortcut Ctrl + M when working inside an active document in MS Word?
A. Indents the paragraph from the left margin boundary
B. Inserts a new manual page break line split
C. Opens the Mail Merge configuration helper pane
D. Applies a strikethrough character formatting layout

Correct Answer: Option A


Explanation:
Ctrl + M increases the left indent of the selected paragraph, moving it inward from the margin. Pressing Ctrl + Shift + M removes or reduces the left indent.

This question belongs to: Computer Microsoft Office