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

C. DMAX()

D. MAXIF()

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

In MS Access, the 'Indexed' property set to 'Yes (No Duplicates)' creates:

A. An index allowing duplicates

B. A foreign key

C. A primary key

D. A unique index, preventing duplicate values

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
No Duplicates enforces uniqueness.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which formula will return '5' from the text 'Excel5'?

A. =LEN("Excel5")

B. =MID("Excel5",2,1)

C. =LEFT("Excel5",1)

D. =RIGHT("Excel5",1)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

This question belongs to: Computer Microsoft Office

Question #3

Which join type in an MS Access Query design view extracts only the rows where the linked key field values match exactly between both tables?

A. Right Outer Join

B. Left Outer Join

C. Full Cross Join

D. Inner Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
An Inner Join is the default join type in MS Access. It extracts records from linked tables only when the values in the joined fields match exactly.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs