Create appropriate x- and y-axis labels a chart title and

Question

Use the following information to build a sales spreadsheet.

You have been assigned the following accounts and provided with the following sales data. This is the total annual sales in dollars for each account in your territory for 2012-2014.

Account	2012	2013	2014
Illinois	116,030	178,970	189,400
Indiana	15,190	1,250	5,004
Iowa	67,890	164,170	83,310
Maryland	65,980	45,280	98,220
Michigan	68,070	55,880	124,550
Michigan State	82,390	100,050	157,790
Minnesota	27,830	79,231	84,900
Nebraska	258,450	219,390	274,880
Northwestern	52,890	46,570	55,570
Ohio State	158,590	209,890	162,440
Penn State	101,200	148,500	138,530
Purdue	111,880	85,089	76,800
Rutgers	110,000	145,000	128.000
Wisconsin	75,000	90,900	111,005
Total	1,311,190	1,687,960	1,670,179

Add the following columns to your spreadsheet (use round numbers -- no decimals):

Two columns with one showing the percentage change for 2012-2013, and one showing the dollar change for 2012-2013.

Two columns with one showing the percentage change for the following year, 2013-2014, and one showing the dollar change for 2013-2014.

You have been assigned a 12% sales goal for 2015. Add one column showing the sales goal, plus two columns showing the forecasted percentage and dollar change for 2014-2015.

Using the spreadsheet,

Use the "Insert Chart" function in Excel to build a bar chart showing three years' worth of sales growth.

Create appropriate X- and Y-axis labels, a chart title, and data labels so that your chart data are appropriately identified (years, dollars, account territory, etc.).

Open a PowerPoint slide, choose a template and formatting, and import your chart into PowerPoint. The idea is to create a sales slide that would be appropriate to present to senior management at your company. For instance, you can add a logo, headers, and other formatting to add to the professional appearance of your assignment.

Save your finalized slide as a PDF.