Microsoft MOS MO-200 Questions & Answers

• Question 21:

  On the ‘Historical Sales’

  Correct Answer: A

  options, advanced. Display options for this worksheet, press show formulas in cells instead of their calculated results.

• Question 22:

  On the ‘’Sales’

  Correct Answer: A

  =UPPER(text)

• Question 23:

  At NOD Publishers, you are preparing a workbook for the company's annual review.

  On the ‘’Summary worksheet, from the existing text in cell A2, insert a hyperlink to ‘’http://www:nodpublishers.com with a ScreenTip that displays ‘’Company Website’

  Correct Answer: A

  Insert, hyperlink.

• Question 24:

  You are analyzing insurance sales data for the first six months of the year.

  On the ‘’New Policies’

  Correct Answer: A

  In the alignment tab, click increase indent.

• Question 25:

  On the ‘’New Policies’

  Correct Answer: A

  Click design and press total row. Click and drag.

• Question 26:

  On the ‘’New Policies’

  Correct Answer: A

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

• Question 27:

  On the ‘’New Policies’

  Correct Answer: A

  Click chart and press "chart design" click style 3.

• Question 28:

  On the ‘’New Policies’

  Correct Answer: A

  =COUNTIFS(***

• Question 29:

  On the ‘’Contact’

  Correct Answer: A

  =LOWER(LEFT(FIRST), LAST), "@domain.com"

• Question 30:

  On the ‘’Last Semester’

  Correct Answer: A

  On the home tab, click find and select and click find. Type agriculture and press find all. Select all and then delete them with the home tab by clicking delete sheet rows.