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. Macros can be executed from the which of the following menu ?

  • Format
  • Home
  • Insert
  • Tools

Answer: Option D

2. Style sheet formats can be applied from ?

  • Table >> Autoformat
  • Format >> Autoformat
  • Table >> Cells
  • Fromat >> Cells

Answer: Option B

3. You will use which feature in excel, if you want to work with one record at a time ?

  • Auto Complete
  • Auto Filter
  • Sub Totals
  • Data Form

Answer: Option D

4. VLOOKUP function used to ?

  • Finds related records
  • Looks up text that contain "v"
  • Check if two cells are identical
  • None of above

Answer: Option A

5. What is shortcut to enter current date in cell in excel ?

  • Ctrl + ;
  • Alt + ;
  • Shift + &
  • Ctrl + $

Answer: Option A

Read more from - MS Excel Questions Answers