PPSCFPSCNTSPakistan govt jobs
- Subject
- Microsoft Excel Mcqscomputer-mcqs › microsoft-excel-mcqs
- Published
- 2 Jul 2024
- Last updated
- 28 May 2026
Explanation
Option C uses the UNIQUE function to extract distinct values from column A, then SORTs them in descending order, and finally INDEX returns the second item in that sorted list, effectively giving the second highest unique value. Options A and B do not handle duplicates properly, while option D finds the second smallest unique value instead.
More Microsoft Excel Mcqs
Practice related questions from the same subject.
- 1.How many predefined margin settings are available by default in MS Excel?
- 2.Which feature allows you to divide the text in a single column into multiple columns in a spreadsheet?
- 3.Which feature in MS Excel enables you to assign custom names to cells or ranges in formulas without relying on selection?
- 4.In MS Word, the "Justify" alignment adjusts text to align evenly on both the left and right margins. How does the "Justify" alignment function in MS Excel?
- 5.Which keyboard shortcut allows you to jump directly to the last row in an Excel worksheet?
- 6.In MS Excel 2016, what is the label of the final column in a worksheet?
- 7.In Microsoft Excel, which function is used to eliminate extra spaces from a text string, leaving only single spaces between words?
- 8.What is the primary purpose of the VLOOKUP function in Excel?
More in Computer Mcqs