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

Related Mcqs:

1. 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

2. What displays the content of active cell?

   A. Name box
   B. Row headings
   C. Formula bar
   D. None of these

   Submitted by: UMAR ASGHAR SANDHU

3. Title bar in MS-Excel displays name of the __________ ?

   A. Worksheet
   B. Workbook
   C. Formula
   D. Location

   Submitted by: Rashid Mehmood

4. Excel displays the current cells address in the __________?

   A. Formula bar
   B. Status bar
   C. Name box
   D. Title bar

   Submitted by: IJAZ UQAAB

5. 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)

   Submitted by: Malik Sanwal

6. Move to next cell in row in Ms Excel:

   A. Tab
   B. Shift
   C. Space
   D. None of these

   Submitted by: FAWAD MATLOOB

7. What is the function of the SUM function in Excel?

   A. To add up a range of cells
   B. To find the average of a range of cells
   C. To count the number of cells in a range
   D. To find the maximum value in a range of cells

   Submitted by: Areesha Khan

8. What is the function of the IF function in Excel?

   A. To perform a logical test and return a value based on the result
   B. To add up a range of cells
   C. To find the average of a range of cells
   D. To count the number of cells in a range

   Submitted by: Areesha Khan

9. What is the function of the VLOOKUP function in Excel?

   A. To perform a vertical lookup and return a value based on a specified criteria
   B. To perform a horizontal lookup and return a value based on a specified criteria
   C. To add up a range of cells
   D. To find the average of a range of cells

   Submitted by: Areesha Khan

10. The default style for new data keyed in a new workbook is ___________?

    A. Comma
    B. Normal
    C. Currency
    D. Percent

    Submitted by: H@yii