MS Excel Questions Answers

• 29. Shortcut to edit the selected cell ?

  1. F3
  2. F8
  3. F4
  4. F2

  Answer :

  Option D

• 30. Gridlines may be turned off for display but turned on for printing.

  1. True
  2. False

  Answer :

  Option A

• 31. When the formula bar is activated, you can see

  1. The Edit Formula button
  2. The Cancel button
  3. The Enter button
  4. All of above

  Answer :

  Option D

• 32. What function displays row data in a column or column data in a row ?

  1. Transpose
  2. Index
  3. Rows
  4. Hyperlinks

  Answer :

  Option A

• 33. VLOOKUP function used to ?

  1. Finds related records
  2. Looks up text that contain "v"
  3. Check if two cells are identical
  4. None of above

  Answer :

  Option A

• 34. Each excel can contain many sheets including worksheets and chart sheets.

  1. True
  2. False

  Answer :

  Option A

• 35. Which shortcut can be used to Switch between open workbooks ?

  1. Ctrl + F2
  2. Ctrl + F6
  3. Ctrl + F8
  4. Ctrl + F10

  Answer :

  Option B