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. Counts the number of cells within a range that meet a single condition

B. Counts all cells containing numbers

C. Counts all non-empty cells

D. Sums cells that meet a condition

Answer: Option A

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

What is the shortcut key to open the 'Replace' dialog in MS Excel?

A. Ctrl + F

B. F5

C. Ctrl + H

D. Ctrl + G

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+H opens Find and Replace with Replace tab active. Ctrl+F opens Find, Ctrl+G is Go To.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the 'Compare' feature allows:

A. Comparing two slide transitions

B. Merging two presentations and reviewing changes

C. Comparing file sizes

D. Comparing fonts

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Compare (Review tab) merges presentations.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, to create a form that displays data from a query, use:

A. Form Wizard or Form Design based on the query

B. Table Analyzer

C. Report Wizard

D. Macro Builder

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms can be bound to tables or queries.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs