What does the COUNTIF function do in Excel? MCQ with Answer and Explanation

What does the COUNTIF function do in Excel?
A. Counts all non-empty cells
B. Sums cells that meet a condition
C. Counts the number of cells within a range that meet a single condition
D. Counts all cells containing numbers
Answer: Option C
Solution (By JKSSB Mock Tests)
COUNTIF counts based on one criterion. SUMIF sums with a condition. COUNT counts only numbers, COUNTA counts non-empty cells.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?
A. Ctrl + Shift + Enter
B. Alt + Enter
C. Ctrl + Enter
D. Shift + Enter

Correct Answer: Option B


Explanation:
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, the shortcut to apply normal style is:
A. Alt + Shift + N
B. Ctrl + Shift + N
C. Ctrl + N
D. Ctrl + Alt + N

Correct Answer: Option B


Explanation:
Ctrl+Shift+N applies Normal style.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following database tools in MS Access is explicitly used to extract selective records matching specific criteria across multiple underlying tables?
A. Macro
B. Report
C. Form
D. Query

Correct Answer: Option D


Explanation:
Queries extract, compile, and filter specific records from multiple interconnected database tables depending on targeted user constraints.

This question belongs to: Computer Microsoft Office