In MS Excel, which function returns the largest value from a range of cells? MCQ with Answer and Explanation

Question

Share Report Error

In MS Excel, which function returns the largest value from a range of cells?

A. MIN()

B. MAX()

C. LARGE()

D. HIGH()

Answer: Option B

Solution (By JKSSB Mock Tests)

MAX() returns the maximum value. MIN() returns minimum. LARGE() returns the k-th largest value. HIGH() is not a valid Excel function.

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, 'AutoCorrect' is used to:

A. Auto-format headings

B. Automatically correct common spelling and typing mistakes as you type

C. Translate text to another language

D. Check grammar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AutoCorrect fixes typos (e.g., 'teh' to 'the').

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Required' field property set to 'Yes' means:

A. The field must be the primary key

B. The field is indexed with duplicates allowed

C. The field cannot be left blank; it must contain a value

D. The field will auto-increment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Required enforces that the field is not null.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, the 'Ctrl + Alt + D' shortcut inserts:

A. An endnote

B. A document property

C. A date

D. A footnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs