Microsoft MOS MO-200 Questions & Answers

• Question 1:

  On the ‘’Inventory

  Correct Answer: A

  Click chart, press layout, click chart title and add it. Press add chart element, data labels,more detailed options, uncheck value and check percentage.

• Question 2:

  You are updating the sales spreadsheet for an online clothing store.

  On the "Quote’

  Correct Answer: A

  Select and press delete on the home tab.

• Question 3:

  On the ‘’Orders’

  Correct Answer: A

  On the data tab, click filter. Display only alpine.

• Question 4:

  On the ‘’Prices’

  Correct Answer: A

  =_*_

• Question 5:

  On the ‘’Prices’

  Correct Answer: A

  Home Tab/ Styles group/ cell styles

• Question 6:

  On the ‘’Prices’

  Correct Answer: A

  =IF(inventory level<15%), "low", ""). Select and drag to apply to other rows

• Question 7:

  On the ‘’Summary

  Correct Answer: A

  [Send us your Suggestion on it.]

• Question 8:

  On the ‘’Region 1’

  Correct Answer: A

  Click sort and filter. Press custom sort and add levels to sort by.

• Question 9:

  You are revising a sales summary report for Northwind Traders.

  On the ‘’Summary’

  Correct Answer: A

  Conditional formatting, highlight cell rules, greater than and then pick the color.

• Question 10:

  On the ‘’Projections

  Correct Answer: A

  [Send us your Suggestion on it.]