What will be the output of the MS Excel formula =LARGE(A1:A4, 2) if cell records carry A1=10, A2=50, A3=30, and A4=40? MCQ with Answer and Explanation

What will be the output of the MS Excel formula =LARGE(A1:A4, 2) if cell records carry A1=10, A2=50, A3=30, and A4=40?

A. 40

B. 50

C. 30

D. #VALUE!

Answer: Option A

Solution (By JKExamLibrary)

The LARGE function returns the k-th largest value in a dataset range. Sorting the range {10, 50, 30, 40} in descending order gives {50, 40, 30, 10}, where the 2nd largest value is 40.

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 of the following is the shortcut to insert a new slide in PowerPoint?

A. Ctrl + D

B. Ctrl + N

C. Ctrl + M

D. Ctrl + I

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+M new slide.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, the function =LARGE(A1:A10, 2) returns:

A. The average of top two

B. The second largest value in the range

C. The smallest value

D. The largest value

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
LARGE(array, k) returns k-th largest.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

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

A. MIN()

B. LARGE()

C. MAX()

D. HIGH()

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
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

Explore All Microsoft Office MCQs