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)
Submitted by: Malik Sanwal
Correct Answer: =INDEX(SORT(UNIQUE(A:A), , -1), 2) ✔
Last Updated: July 02, 2024
Related MCQs
- In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?
- What is the function of Vlookup formula in Excel ?
- In Excel, Conditional formatting is in: __________?
- In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?
- What does the term “filter” refer to in Excel?
- What are the small squares arranged in rows and columns called in Excel?
- Maximum zoom percentage in Excel is _________?
- Default file name in MS Excel is?
- To insert chart in MS Excel, which shortcut key used?
- What is the function of the VLOOKUP function in Excel?
- What is the function of the IF function in Excel?
- What is the function of the SUM function in Excel?
- What is the intersection of a column and row called in Excel?
- Title bar in MS-Excel displays name of the __________ ?
- in MS-Excel__________ short cut key is used for hiding rows.
- Which of following is not an element of computer spreadsheet interface?
- Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?
- What is a cell in Excel?
- In excel columns are labelled as__________?
- which of the following is not a valid Zoom percentage in Excel?
- User developed instruction for excel are called__________?
- Which function calculates the largest value in a set of numbers in Excel?
- What displays the content of active cell?
- In a computer spreadsheet, block of cells is called __________ ?
- Microsoft Excel 2019 files have a default extension of__________?
- In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?
- In Ms Excel, which of the following special function keys allow the content in cell?
- Ctrl+Shift+1 shortcut Keys in excel are used to __________?
- Which Shortcut keys are used to strikethrough highlighted selection in Excel?
- Which of the following is the latest version of MS Excel?
- In MS Excel, Conditional Formatting is in ______ tab?
- Which of the following you can paste selectively using Paste Special Command?
- You can set page border in excel from: __________?
- Excel displays the current cells address in the __________?
- The first cell in excel worksheet is labeled as _________?
- An excel workbook is a collection of __________?
- Which of these key are used in ms excel to insert current time In workbook.
- Getting data from a cell located In a different sheet is called __________?
- Which element is deficient in milk _________?
- In Ms Excel Ready made templates are available under _______ tab ?
- You can edit existing Excel data by pressing the:________ key?
- When you insert an Excel file into a word document, the data are?
- The Greater Than sign is an example of ________ operation ?
- Which function displays row data into column or column data into row?
- Microsoft Office InterConnect is:
- Microsoft Office Accounting is:
- Microsoft Office Suite spreadsheet program is _________?
- Move to Next Sheet in Ms Excel:
- Move to next cell in row in Ms Excel:
- Which of these keys are used in Ms Excel to copy formula from above cell?
- Which of these keys are used in Ms Excel to copy value from above cell?