Microsoft MOS MO-200 Questions & Answers

• Question 11:

  On the ‘’Instructional Hours’

  Correct Answer: A

  Click on the green plus sign and press axis titles.

• Question 12:

  On the ‘’Classes’

  Correct Answer: A

  design, convert to range

• Question 13:

  On the ‘Comparison

  Correct Answer: A

  Right click and open axis options. Check the box that says values in reverse order.

• Question 14:

  On the ‘’Instructional Hours’

  Correct Answer: A

  Home tab, cells group, click format. Click column width.

• Question 15:

  You are compiling class data to present to the enrollment director at the School of Fine Art.

  On the ‘’Substitutes’

  Correct Answer: A

  File. Open.

• Question 16:

  From the ‘’Graduation’

  Correct Answer: A

  Right click on the chart. Click move chart. Click new sheet and rename it.

• Question 17:

  On the ‘’Authors’

  Correct Answer: A

  =IF(books sold>10,000, "500", "100"). Select and drag to apply to other rows

• Question 18:

  On the ‘’Enrollment’

  Correct Answer: A

  Select a blank cell and press insert. Pick column sparklines. Select the data range. Click and drag the bottom right corner for more.

• Question 19:

  Remove hidden properties and personal information from the workbook. Do not remove any other content.

  A. Check the Solution below.

  B. PlaceHolder

  C. PlaceHolder

  D. PlaceHolder

  Correct Answer: A

  File, check for issues, inspect, remove all. Click close.

• Question 20:

  On the ‘’Summary’

  Correct Answer: A

  Right click inside chart. Press select data. Press add. Add series name and series value (make sure to delete previous data.