Independent Challenge 3 expenses
You are working as an account representative at a magazine called Creativity. You have been examining the expenses Incurred recently. The CEO has asked you to prepare charts that can be used in this evaluation. In particularly you also want to see how dollar amounts compare among the different expenses and you want to see how expenses compare with each other proportional to the total budget.
a. Start Excel, open the Data File EX D-5.xlsx from the location where you store your data files, then save it as EX D-Creativity Magazine
b. Identify three types of charts that seem best suited to illustrate the data in the range A16:B24. What kind of chart enhancement are necessary?
c Create at least two different types of charts that show the distribution of circulation expenses. a c each chart to a new location on the same worksheet.) One of the charts should be a 3-D pie chart.
e. Change the color of at least one data series in at least one of the charts.
f. Add chart titles and category and value axis titles where appropriate. Format the titles with a font of your choice. Apply a shadow to the chart title in at least one chart.
g. Explode your name to a section of the header, then save your work.
h .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 one page. Compare your work to the sample in FIGURE D-29.
k. Submit your work to your instructor as directed, close the workbook, then exit Excel.
tt
FIGURE D-29
Your Name
Circulation Expenses
Type Newspaper Podcasts TV Sponsor Yellow Pages Blow-in cards Magazine Pens Podcasts Billboard Billboard Total
Inv Date Placed with 01-Jan-16 Village Reader 07-Jan-16 WHAT 20-Jan-16 Advertising Concepts 01-Jan-16 NYNEX 13-Jan-16 Advertising Concepts 07-Jan-16 Young Upstart 05-Jan-16 Mass Appeal, Inc. 15-Jan-16 WHAT 12-Jan-16 Advertising Concepts 28-Jan-16 Advertising Concepts
Summary Amount Billboard $ 2,343.01 Blow-in cards $ 77,00 Pens $ 33,83 Podcasts $ 2,325.00 TV Sponsor $ 7,500 00 Yellow Pages $ 1,163.20 Newspaper $ 659,44 Magazine $ 1,211.04 Total $ 15,312,52
Cost ea. 82.43 77.50 250.00 232.64 0.22 100.92 0.12 77.50 101,87 101.87 1,025,07
Quantity 8 15 30 5 350 12 275 15 9 14 733
Ext. Cost 659.44 $ 1,162,50 $ 7,500.00 1,163.20 $ 1,27171.0040 $$:1,16323.’8503 1,492166,8183 $ 15,312,52
Creativity Magazine Circulation Expenses $659.44 ‘10
Billboard TV Sponsor
N Blow-in cards. P Pens $ Yellow Pages a Newspaper
Greatest Expense Sli3O00.00 $7,00000 56,000.00 $5,0(X).00 $4,000.00 $3 Sko $2 poo $1,000,00
Amount (In $)
POdcasts lb’ ‘VI OBOZItie
S.
6 S T Expense At’ 44z*’
