Which function in MS Excel counts only the cells that match a specific user-defined condition or logical rule? MCQ with Answer and Explanation

Question

Share Report Error

Which function in MS Excel counts only the cells that match a specific user-defined condition or logical rule?

A. COUNTBLANK

B. COUNTA

C. COUNTIF

D. COUNT

Answer: Option C

Solution (By JKSSB Mock Tests)

COUNTIF counts cells in a range that meet a single criteria argument (e.g., counting cells with values greater than 50).

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

Share Report

In Excel, the function =OFFSET(A1,1,2) returns the value of cell:

A. A2

B. C1

C. C2

D. B2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
OFFSET(A1,1 row down, 2 columns right) gives C2.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which of the following database tools in MS Access is designed to summarize, group, and format table information for clear paper printing or digital distribution?

A. Report

B. Form

C. Query setup

D. Macro asset

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Reports are specialized database objects used to organize, summarize, and format data from tables or queries for printing or professional distribution.

This question belongs to: Computer Microsoft Office