- By Joan Lambert
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.