MS Excel Questions Answers

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

  1. From Format Cells dialog box choose Merge and Center check box
  2. Click on Merge and Center tool on formatting toolbar
  3. From Format Cells dialog box select the Centered alignment
  4. From Format Cells dialog box click on Merge Cells check box

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 72. On Excel screen, Tab scroll buttons are

  1. towards the top left corner
  2. towards the top right corner
  3. towards the bottom right corner
  4. towards the bottom left corner

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 73. Choose from the following, which is not the correct method of editing the cell content ?

  1. Press the Alt key
  2. Press the F2 key
  3. Double click the cell
  4. Click the formula bar

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

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

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

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 75. When you press Ctrl + X after selecting some cells in Excel, what will happen then

  1. The cell content of selected cells disappear from cell and stored in clipboard
  2. The selected cells are deleted and cells are shifted up
  3. The selected cells are deleted and the cells are shifted left
  4. The cells selected are marked for cutting

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 76. In Paste Special dialog box, which of the following option is not available ?

  1. Divide
  2. Add
  3. Subtract
  4. Square root

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

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

  1. Edit -> Paste Special -> Transpose
  2. Cut and Paste
  3. Both of above
  4. None of above

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question