Create charts and objects

  • 7/6/2017

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.