In Excel, which function returns the largest value from a range that meets multiple criteria? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the largest value from a range that meets multiple criteria?

A. MAXIF()

B. DMAX()

C. MAXIFS()

D. LARGEIFS()

Answer: Option C

Solution (By JKSSB Mock Tests)

MAXIFS available in Excel 2019/365.

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

In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. Only if #DIV/0!

B. If B1 is zero

C. A1/B1 results in any error value

D. If A1 is blank

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
IFERROR catches all error types and returns specified value.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the 'Watch Window' is used to:

A. View all open workbooks

B. Audit formulas

C. Monitor the values of cells in a separate window while working

D. Track changes to the workbook

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Watch Window (Formulas tab) keeps selected cells visible.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, which shortcut key is used to insert a new comment?

A. Ctrl + Shift + M

B. Alt + M

C. Ctrl + M

D. Ctrl + Alt + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+M inserts comment.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs