download Mastguru Android App

Question Detail

To convert a column of data into row, which command will you choose

  • Edit -> Paste Special -> Transpose
  • Cut and Paste
  • Both of above
  • None of above
Similar Questions :

1. What term refers to a specific set of values saved with the workbook ?

  • Range
  • File set
  • Data set
  • Scenario

2. The name box appears at the ?

  • left of the formula bar
  • right of the formula bar
  • below the status bar
  • below the menu bar

3. In Excel Worksheet how can you show or hide the gridlines ?

  • Click Gridline tool on Forms toolbar
  • Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • Both of above
  • None of above

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

  • /
  • *
  • $
  • =

5. Formula palette is used to ?

  • format cells containing numbers
  • create and edit formulas containing functions
  • entered assumptions data
  • copy all cells
Read more from - MS Excel Questions Answers
Post a comment