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

Question Report Error

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

A. HIGH()

B. LARGE()

C. MAX()

D. MIN()

Answer: Option C

Solution (By JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

What is the maximum number of columns in a table in MS Word?

A. 63

B. No limit

C. 10

D. 256

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
A Word table can have up to 63 columns.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, which function returns the year from a date?

A. DAY()

B. YEAR()

C. MONTH()

D. YEARFRAC()

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
YEAR(serial_number) returns year.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, which option is used to set the slide show to loop continuously?

A. Animations -> Repeat

B. Transitions -> Advance Slide -> After

C. Slide Show -> Set Up Show -> Loop continuously until 'Esc'

D. Design -> Loop

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Loop setting in Set Up Show.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs