MO-200 Sample Questions Answers

On the ‘’Enrollment’’ worksheet, in cells G5:G25, insert Column sparkliness to compare the last, current, and next term values for each class period.

On the ‘Comparison’ chart sheet, swap the data the axis.

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.’’

On the ‘’New Policies’’ worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.

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.

On the ‘’Inventory’ chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.

On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’