The expenses charts that can be used in this evaluation. hi particular, you wan called Creativity. you have been examining I to the total budget. want to lation and has asked you to prepare Independent Challenge 3 You are working as an account representative at a magazine d to increase mounts compare among the difference see howcclirocILIar a proportiona store your Data Files, it as What kin Incurred recently. The CEO wants to examine expenses designe rent l

a. Start Excel, open the Data File EX D-5.xisx from the location vio:beer:* you expenses, and you also want to see how expenses compare with each Files then save i enhancements are necessary? the data in the range A16:B24. W kinds of than EX ID-Creativity Magazine.

b). Identify three types of charts that seem best suited to illustrate he data in the range A16:B24What kind of chart enhancement are necessary

c. Create at least two different types of charts that show the distribution of circulation expenses. (Hint: Move each chart to a new location on the same worksheet.) One of the charts should be a 3-D pie chart.

d. In at least one of the charts, add annotated text and arrows highlighting imp oaant data, such as the largest expert,

e. Change the color of at least one data series in at least one of the ch e. arts.Format the titles with a font of your choice.

f. Add chart titles and category and value axis titles where appropriate Apply a shadow to the chart title in at least one chart.

g. Add your name to a section of the header, then save your work. It. Explode a slice from the 3-D pie chart.

i. Add a data label to the exploded pie slice.

j. Preview the worksheet in Backstage view. Adjust any items as needed. Be sure the charts are all visible on o Compare your work to the sample in FIGURE 0-29. one page. our w

k. Submit your work to your instructor as directed, close the workbook, then exit Excel.