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 smallest value

B. The largest 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 keyboard shortcut opens the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word?

A. Ctrl + G

B. Ctrl + R

C. Ctrl + H

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + H opens the Find and Replace dialog box focusing immediately on the Replace tab. Ctrl + F launches the Navigation/Find pane.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, what is the default value for 'Allow Zero Length' property?

A. Null

B. True

C. No

D. Yes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
By default, zero-length strings are not allowed.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, which button allows you to present online to remote viewers?

A. Skype Meeting

B. Broadcast Slide Show

C. Share via OneDrive

D. Present Online (or Office Presentation Service)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Present Online (Office Presentation Service) lets others view in a browser. In newer versions, it's 'Present Online' or 'Share'. Broadcast Slide Show was older term.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs