MS Excel Questions Answers

• 43. How we can view a cell comment ?

  1. position the mouse pointer over the cell
  2. click the comment command on the view menu
  3. click the edit comment commands on the Insert menu
  4. click the Display comment command on the window menu

  Answer :

  Option A

• 44. Which function is used for creating a data table ?

  1. fashion is the need of the day
  2. the excessive craze for fashions is detrimental to ones personality.
  3. the hoard for fashion should be done away with so as not to let down the constuctive development.
  4. work and other activities should be valued more than the outward appearance.
  5. Sum
  6. Table
  7. Add
  8. Count

  Answer :

  Option F

• 45. A Spreadsheet contains ?

  1. data in statement I alone are sufficient to answer the question.
  2. data in statement II alone are sufficient to answer the question.
  3. data either in statement I alone or in statement II alone are sufficient to answer the question.
  4. data given in both statements I and II together are not sufficient to answer the question.
  5. data in both statements I and II together are necessary to answer the question.
  6. columns
  7. rows
  8. rows and columns
  9. None of above

  Answer :

  Option

• 46. Which dialogue box we can use to name a constant ?

  1. Create Name
  2. Define Name
  3. Get Name
  4. Create Constant

  Answer :

  Option B

• 47. Insert picture option is in which of the following toolbars ?

  1. Standard
  2. Formatting
  3. Drawing
  4. Picture

  Answer :

  Option D

• 48. You can convert existing Excel worksheet data and charts to HTML document by using the ?

  1. Internet Assistant Wizard
  2. Intranet Wizard
  3. Import Wizard
  4. Export Wizard

  Answer :

  Option A

• 49. When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors.

  1. True
  2. False

  Answer :

  Option A