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

Question

Share Report Error

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. 50

B. #VALUE!

C. 30

D. 40

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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

What is the function of the keyboard shortcut Ctrl + F2 across Microsoft Word and Excel applications?

A. Displays the Print Preview layout tab screen

B. Launches the automated spelling check wizard

C. Minimizes the core active parent window application

D. Opens the Save As file dialog menu window

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + F2 is the traditional keyboard shortcut to launch the Print Preview screen, allowing users to check document layouts before physical printing.

This question belongs to: Computer Microsoft Office