Create charts and objects

Objective 5.2 practice tasks

The practice files for these tasks are located in the MOSExcel2016\Objective5 practice file folder. The folder also contains a result file that you can use to check your work.

• Open the Excel_5-2 workbook, display the Sales worksheet, and do the following:

  • Change the pie chart to a 3-D Clustered Column chart.

  • Apply Layout 1, Style 7 to the chart.

  • Apply the Subtle Effect – Olive Green, Accent 3 shape style.

  • Increase the size of the chart until it occupies cells A1:L23.

  • Move the chart to a new chart sheet named Sales Chart.

• On the Seattle worksheet, do the following:

  • Add the title Air Quality Index Report to the chart.

  • Add data labels that show the percentage of the whole that is represented by each data marker.

• Save the Excel_5-2 workbook.

• Open the Excel_5-2_results workbook. Compare the two workbooks to check your work.

• Close the open workbooks.