In Excel, which function returns the smallest number in a range that meets a condition? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the smallest number in a range that meets a condition?

A. MINIF()

B. DMIN()

C. SMALLIF()

D. MINIFS()

Answer: Option D

Solution (By JKSSB Mock Tests)

MINIFS returns minimum 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 Word, the 'Compare' feature is used to:

A. Measure reading level

B. Compare two versions of a document and show differences

C. Check grammar

D. Compare document with a template

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Compare (Review tab) merges and highlights changes between two documents.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type automatically inserts a unique sequential number?

A. Text

B. Calculated

C. AutoNumber

D. Number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AutoNumber increments automatically.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, to display the 'Go To' dialog, press:

A. Both A and B

B. Alt + G

C. Ctrl + G

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F5 and Ctrl+G both open Go To.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs