Home›Browse›MS Office & Productivity›MCQ
easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

A=LARGE(A:A, 2)
B=LARGE(UNIQUE(A:A), 2)
C=INDEX(SORT(UNIQUE(A:A), , -1), 2)
D=SMALL(UNIQUE(A:A), 2)

Choose an option to check yourself, or reveal the answer and explanation instantly.

More MS Office & Productivity MCQs

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

FPSCNTSCSSPPSC

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizMore MCQs
Answer and explanation

Correct Answer: C: =INDEX(SORT(UNIQUE(A:A), , -1), 2)

Explanation: The correct answer is C: =INDEX(SORT(UNIQUE(A:A), , -1), 2). The LARGE(UNIQUE(A:A),2) returns the second largest value, but after removing duplicates, the INDEX+SORT combination properly retrieves the second highest unique value. The UNIQUE function filters duplicates, SORT arranges descending, and INDEX picks the second position.

In MS Excel, you have a list of sales data in column A, and you nee...