Create charts and objects

Objective 5.1 practice tasks

The practice file for these tasks is 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-1 workbook and do the following:

  • Plot the data on the Seattle worksheet as a 2-D Pie chart on that worksheet.

  • Plot the data on the Sales worksheet as a simple two-dimensional column chart.

• On the Fall Sales worksheet, do the following:

  • Switch the rows and columns of the chart.

  • Change the October sales amount for the Flowers category to 888.25 and ensure that the chart reflects the change.

  • Expand the data range plotted by the chart to include November, so that you can compare sales for the two months.

• Save the Excel_5-1 workbook.

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

• Close the open workbooks.