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

B. MINIF()

C. DMIN()

D. SMALLIF()

Answer: Option A

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

Share Report

In MS Access, which property defines the pattern for data entry (like phone number)?

A. Validation Rule

B. Default Value

C. Format

D. Input Mask

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Input Mask controls entry format.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, to repeat the last action, press:

A. Both A and B

B. F4

C. Ctrl + Y

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F4 repeats last action; Ctrl+Y redoes. Often they overlap.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, what is the shortcut to apply single line spacing?

A. Ctrl + 0

B. Ctrl + 2

C. Ctrl + 5

D. Ctrl + 1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+1 single, Ctrl+2 double, Ctrl+5 1.5 line spacing. Ctrl+0 adds/removes space before paragraph.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs