Navigate

Question Detail

What function displays row data in a column or column data in a row ?

  • Transpose
  • Index
  • Rows
  • Hyperlinks

Answer: Option A

Similar Questions :

1. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

  • C1:10H
  • C1:H10
  • C1:H-10
  • C1:H:10

Answer: Option B

2. Which function is used for creating a data table ?

  • Sum
  • Table
  • Add
  • Count

Answer: Option B

3. To join some cells and place the content at the middle of joined cell, which tool you will use?

  • From Format Cells dialog box choose Merge and Center check box
  • Click on Merge and Center tool on formatting toolbar
  • From Format Cells dialog box select the Centered alignment
  • From Format Cells dialog box click on Merge Cells check box

Answer: Option B

4. How we can view a cell comment ?

  • position the mouse pointer over the cell
  • click the comment command on the view menu
  • click the edit comment commands on the Insert menu
  • click the Display comment command on the window menu

Answer: Option A

5. How is data organized in a spreadsheet ?

  • Rows and columns
  • Layers and planes
  • Lines and spaces
  • Height and width

Answer: Option A

Read more from - MS Excel Questions Answers