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

B. MAXIF()

C. DMAX()

D. LARGEIFS()

Answer: Option A

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

Share Report

In MS Access, which query type can be executed to add brand new rows of records from an external source or table directly into an existing table?

A. Make-Table Query

B. Append Query

C. Update Query

D. Delete Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An Append Query selects records from one or more data sources and adds them to the end of an existing target table.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, to insert an index, go to:

A. References -> Insert Index

B. Review -> Index

C. Insert -> Index

D. Layout -> Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Index is under References tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is the correct extension for an Excel binary workbook for large datasets?

A. .xlsm

B. .xltx

C. .xlsb

D. .xlsx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
.xlsb is binary workbook, faster for large data.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs