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. COUNTIFS()

B. COUNTIF()

C. DCOUNT()

D. SUMIFS()

Answer: Option A

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

In MS Access, which data type stores a calculated value that depends on other fields?

A. Calculated

B. Memo

C. Number

D. AutoNumber

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Calculated data type creates a field whose value is computed.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In PowerPoint, which of the following views displays a small image of each slide with its transition and timing?

A. Normal view

B. Slide Sorter view

C. Reading view

D. Outline view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Sorter shows thumbnails and can display transition icons and timings below slides.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, which button allows you to present online to remote viewers?

A. Broadcast Slide Show

B. Present Online (or Office Presentation Service)

C. Share via OneDrive

D. Skype Meeting

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Present Online (Office Presentation Service) lets others view in a browser. In newer versions, it's 'Present Online' or 'Share'. Broadcast Slide Show was older term.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs