In Excel, which function is used to return the smallest value that meets a condition? MCQ with Answer and Explanation

In Excel, which function is used to return the smallest value that meets a condition?
A. MIN
B. SMALL
C. MINIFS
D. MINA
Answer: Option C
Solution (By JKSSB Mock Tests)
MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?
A. #NUM!
B. #NAME?
C. #DIV/0!
D. #VALUE!

Correct Answer: Option A


Explanation:
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, what is the default value for 'Allow Zero Length' property?
A. True
B. Yes
C. Null
D. No

Correct Answer: Option D


Explanation:
By default, zero-length strings are not allowed.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, 'Slide Show' menu offers 'Custom Slide Show' to:
A. Apply custom animations to all slides
B. Change slide orientation
C. Record narration
D. Play only selected slides in a specific order

Correct Answer: Option D


Explanation:
Custom Slide Show presents a subset of slides.

This question belongs to: Computer Microsoft Office