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?

Related Mcqs:

1. With which of the following all formulas in excel starts ?

   A. /
   B. *
   C. $
   D. =

   Submitted by: H@yii

2. Which function displays row data into column or column data into row?

   A. Hyperlink
   B. Index
   C. Transpose
   D. Rows

   Submitted by: Mansoor Ahmed Suhag

3. What is the intersection of a column and row called in Excel?

   A. A cell
   B. A range
   C. A column header
   D. A row header

   Submitted by: Areesha Khan

4. When you insert an Excel file into a word document, the data are?

   A. Hyperlinked
   B. placed in a word table
   C. linked
   D. embedded

   Submitted by: Mansoor Ahmed Suhag

5. You can edit existing Excel data by pressing the:________ key?

   A. F1 Key
   B. F2 Key
   C. F3 Key
   D. F4 Key

   Submitted by: SYED AKASH BUKHARI NAQEEBI

6. Which function calculates the largest value in a set of numbers in Excel?

   A. Average
   B. Count
   C. Minimum
   D. Maximum

   Submitted by: UMAR ASGHAR SANDHU

7. Which of these keys are used in Ms Excel to copy value from above cell?

   A. Ctrl + “
   B. Ctrl+ E
   C. Ctrl+ E
   D. Ctrl+ D

   Submitted by: FAWAD MATLOOB

8. Which of the following is the latest version of MS Excel?

   A. Excel 2016
   B. Excel 2017
   C. Excel 2021
   D. Office 365

   Submitted by: Malik Asghar Hussain

9. which of the following is not a valid Zoom percentage in Excel?

   A. 10
   B. 100
   C. 300
   D. 500

   Submitted by: Taimur Gulzar

10. 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?

    A. TRIM
    B. SUBSTITUTE
    C. CLEAN
    D. REPT

    Submitted by: Malik Sanwal