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

You are compiling data about courses at Bellows College.

On the ‘’Last Semester’’ worksheet configure A3:F3 to automatically wrap the text.

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.