In Excel, the function =LARGE(A1:A10, 2) returns: MCQ with Answer and Explanation

Question

Share Report Error

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

A. The largest value

B. The smallest value

C. The average of top two

D. The second largest value in the range

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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

Which tab contains the 'Slide Master' command in MS PowerPoint?

A. Home

B. Design

C. Insert

D. View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Master is located under the View tab, in the Master Views group. It is not in Design, though Design affects themes.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which of the following is a valid object in MS Access database?

A. Table

B. Form

C. Query

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are objects.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, what is the function of the 'Crop' tool?

A. To rotate an image

B. To change the brightness of an image

C. To resize an image

D. To remove unwanted areas of an image

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs