MO-200 Exam Dumps : Microsoft Excel (Excel and Excel 2019)

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

On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula instead of a cell reference or value.

On the ‘’Next Semester’’ worksheet, create a Clustered Column chart that displays the ‘’Program’’ names and the ‘’Average Cost per student’’ data. Place the chart to the right of the table. The exact size and position of the chart do not matter.