MO-200 Microsoft Excel (Excel and Excel 2019) Questions and Answers

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.

On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.