In Excel, which function returns the number of cells in a range that meet multiple criteria? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the number of cells in a range that meet multiple criteria?

A. SUMIFS()

B. DCOUNT()

C. COUNTIF()

D. COUNTIFS()

Answer: Option D

Solution (By JKSSB Mock Tests)

COUNTIFS handles multiple criteria.

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

Which of the following is a valid shortcut to open the 'Save As' dialog box in MS Office?

A. Alt + S

B. Shift + S

C. Ctrl + S

D. F12

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F12 opens the Save As dialog box. Ctrl + S saves the current file (or opens Save As if new). Alt+S is not standard.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?

A. Slide Sorter view

B. Reading view

C. Normal view

D. Notes Page view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Sorter view shows miniature slides, allowing reordering. Normal view is for editing, Reading view for presentation preview.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut to select all text in a document in MS Word?

A. Shift + Home

B. Ctrl + S

C. Ctrl + F5

D. Ctrl + A

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs