In Excel, which function is used to find the smallest value in a range? MCQ with Answer and Explanation

In Excel, which function is used to find the smallest value in a range?
A. SMALL
B. MINA
C. MINIFS
D. MIN
Answer: Option D
Solution (By JKExamLibrary)
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In PowerPoint, which feature automatically adjusts the size of text to fit within a placeholder?
A. Both A and B
B. Shrink text on overflow
C. AutoFit
D. Text Scaling

Correct Answer: Option A


Explanation:
AutoFit options: Shrink text on overflow, Resize shape to fit text.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the keyboard shortcut to insert a hyperlink in MS Excel?
A. Ctrl + K
B. Ctrl + H
C. Ctrl + I
D. Ctrl + L

Correct Answer: Option A


Explanation:
Ctrl + K is the universal shortcut to insert a hyperlink in Microsoft Office applications, including Excel, Word, and PowerPoint.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Access, which of the following is a valid way to set a primary key?
A. Set in Datasheet View
B. Right-click the field in Design View and select Primary Key
C. Both A and B
D. Use the Primary Key button in Design View

Correct Answer: Option C


Explanation:
You can set primary key by right-clicking or clicking the Primary Key button in Design View.

This question belongs to: Computer Microsoft Office