easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Continue practising this MCQ topic
Use these links to review the full topic, start a timed quiz, or open the exam hub connected with this question.
Related MS Office & Productivity MCQs
View all1In Ms Excel Ready made templates are available under _______ tab ?2What Power point feature will you use to apply motion effects to different objects of a slide ?3You can edit existing Excel data by pressing the:________ key?4To go to a specific location in a document we use :5You can edit an embedded organization chart object by_______________?6Which of the following is not a way to create a new presentation?
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.
Continue practice
More MS Office & Productivity MCQs with answers
Use these links to review related questions, practise the full topic, or open the exam preparation pages connected with this MCQ.
Related questions
- In Ms Excel Ready made templates are available under _______ tab ?
- What Power point feature will you use to apply motion effects to different objects of a slide ?
- You can edit existing Excel data by pressing the:________ key?
- To go to a specific location in a document we use :
- You can edit an embedded organization chart object by_______________?
- Which of the following is not a way to create a new presentation?