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

Question Report Error

In Excel, which function is used to return the smallest value that meets a condition?

A. MINIFS

B. MINA

C. MIN

D. SMALL

Answer: Option A

Solution (By JKExamLibrary)

MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.

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

Which keyboard shortcut is used to select all content in a document?

A. Ctrl + Shift + A

B. Ctrl + S

C. Ctrl + Alt + A

D. Ctrl + A

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Ctrl + A selects all. Ctrl + S saves, Ctrl + Shift + A toggles all caps.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What does the 'Ctrl + 0' (zero) shortcut do in MS Word?

A. Sets font size to 0

B. Hides the selected text

C. Adds or removes one line space before a paragraph

D. Clears formatting

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+0 toggles 12-point space before a paragraph.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS PowerPoint, which option is used to add a footnote to a slide?

A. Review > Footnote

B. Insert > Footnote

C. Insert > Header & Footer

D. View > Footnote

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Footnotes in PowerPoint are added via Header & Footer (then Footer tab). There is no specific Footnote command.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs