Free Microsoft MO-200 Exam Dumps Questions & Answers

On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.

On the ''New Policies'' worksheet, in the ''Inactive Months column, use a function to count the number of months with no new policies, by Agent.
Check the Solution below.

You are analyzing insurance sales data for the first six months of the year.
On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent).
Set the indent to 1.
Check the Solution below.

You are revising a sales summary report for Northwind Traders.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.

Correct Answer:

Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.

On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
Check the Solution below.