MS Excel Questions Answers

• 29. 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 And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

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

  1. True
  2. False

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 31. How do you change column width to fit the contents ?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 32. To insert three columns between columns A and B you would

  1. Select column A
  2. Select A and B
  3. Select B
  4. All of above

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 33. To drag a selected range of data to another worksheet in the same workbook, use the ?

  1. Ctrl key
  2. Shift key
  3. Alt key
  4. Tab key

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 34. You can activate a cell by ?
  

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of above

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 35. A function inside another function is known as ?

  1. Round function
  2. Sandwich function
  3. Switch function
  4. Nested function

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question