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

Question
In Excel, the function =LARGE(A1:A10, 2) returns:
A. The largest value
B. The average of top two
C. The second largest value in the range
D. The smallest value
Answer: Option C
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
In MS Access, what field property specifies that text inside a field should always be displayed in uppercase regardless of how it was typed?
A. Input Mask set to >
B. Format set to >
C. Field Size constraint management
D. Validation Rule set to UPPER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In the Format property of a text field, entering the greater-than symbol (>) forces Access to display all characters in uppercase, without altering the underlying raw data records.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to calculate the probability of a given z-score?
A. NORM.S.DIST
B. PROB
C. Both A and B
D. NORM.DIST
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NORM.DIST and NORM.S.DIST both calculate normal distribution probabilities (standard and non-standard).
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which field size validation rule limits a Short Text entry to contain at most 50 characters?
A. Field Size
B. Input Mask
C. Validation Rule
D. Format Limit
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Field Size property specifies the maximum character storage capacity limit allowed for Short Text fields.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.