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

Question

Share Report Error

What does the COUNTIF function do in Excel?

A. Sums cells that meet a condition

B. Counts all cells containing numbers

C. Counts the number of cells within a range that meet a single condition

D. Counts all non-empty cells

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.

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 of the following formulas is valid in MS Excel to find the highest value from cells A1 through A10?

A. =MAXIMUM(A1:A10)

B. =TOP(A1:A10)

C. =MAX(A1:A10)

D. =HIGH(A1:A10)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The native function name to extract the maximum number from a given range of cells in Excel is MAX.

This question belongs to: Computer Microsoft Office

Question #2

Which view in MS PowerPoint displays the speaker notes alongside a large preview of the active slide and a thumbnail preview of the upcoming slide?

A. Notes Page View

B. Presenter View

C. Outline View

D. Reading View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Presenter View is a dedicated view designed for the presenter when projecting, showing the current slide, next slide, timer, and notes.

This question belongs to: Computer Microsoft Office

Question #3

In MS Excel, what is the exact output of the formula =TEXT(DATE(2026,6,18), dddd)?

A. 18

B. June

C. Thursday

D. Thu

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The TEXT function formats a numeric date value into a text representation based on a specified format code. The code dddd returns the full name of the day of the week (June 18, 2026 is a Thursday).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs