In Excel, which function returns the largest number in a range that meets a condition? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the largest number in a range that meets a condition?

A. MAXIFS()

B. DMAX()

C. MAXIF()

D. LARGEIF()

Answer: Option A

Solution (By JKSSB Mock Tests)

MAXIFS (Excel 2019+) returns maximum based on 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 Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5?

A. Relative Cell Reference

B. Mixed Cell Reference

C. External sheet reference link

D. Absolute Cell Reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
An absolute cell reference locks both the column letter and the row number with dollar signs ($C$5), ensuring that the reference does not change when the formula is copied to another cell.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which feature is used to add a text placeholder that can be edited on the slide?

A. Shape

B. WordArt

C. Text Box

D. Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Text Box is a rectangular area where you can type and format text independently. WordArt is styled text, Shape can contain text, but Text Box is specifically for editable text.

This question belongs to: Computer Microsoft Office