Free Microsoft MO-200 Exam Dumps Questions & Answers

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 ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' Check the Solution below.

You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ''Substitutes'' worksheet beginning at cell A1, import the data from the Substitutes text file in the Documents folder. Use the first row of the data source as headers.
Check the Solution below.

Correct Answer:

File. Open.
Topic 4, Book SalesCase Study
Exhibit.

On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.

On the ''Prices'' worksheet, in the ''inventory Notice'' column, use a function to display ''Low'' if the '' inventory Level % is below 15%. Otherwise, leave the ''Inventory Notice'' blank.
Check the Solution below.

Correct Answer:

=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.