Graphical representation of the expenses

Question

Assignment:

You are going to create a chart showing the expenses in the categories listed below. You first need to calculate the data in a summary section of your spreadsheet. Then, you can use that data in that summary section to create the chart. First, in cells K16:K21, enter the following labels (headers): Summary, Travel, Meals, Entertain, Phone, Other. Cells M17 through M21 will hold the data you will add to get the total expense for each category. For example, if you went on a business trip, you would need to enter the amount you spent on travel in one cell, the amount you spent on meals in another cell,and so on. Then you would use the add function to get a total of your expenses for the trip. Next, in cells M17 through M21 , create formulas to calculate the total expenses for each category:
For Travel, include expenses for Ground and Air transportation, Lodging, and Mileage $.

For Meals, include expenses for Brkfast, Lunch, and Dinner.

Finally, in cell M22, enter a function to show the total of M17:M21.You can now use this summary to create the column chart.

Create a column chart to show the graphical representation of the expenses, using the figure below as a guide. Create the chart on its own chart sheet, named Expense Report Chart. Do not include a legend but include the title "Expenses." Include data labels.

Use the Drawing toolbar to add the following Line callouts, as shown in the figure:
Travel consists of Air + Ground + Lodging + Mileage $.
Meals consist of Brkfast + Lunch + Dinner.
Rename the sheet tab for the spreadsheet Expense Report.

Fill in the blank cells in range A8:M11 with numeric values. You may choose to fill those cells with 0s (zeros), or any other number you may choose. Save your finished workbook as Expense

Department Lookup
Dept#	Dept Name
1000	Sr Management
1100	Adminstration
1200	Sales
1500	IT
1510	Web Operations
1520	Corporate IT
1600	Product Development

Expense Report
	Department Number	1000	Sr Management
												Allowance
		Transportation			Meals							0.32
Date	Description	Air	Ground	Lodging	Brkfast	Lunch	Dinner	Entertain	Phone	Other	Miles	Mileage $	Total
15-Feb	Conference in Texas	475.00	55.00	120.00		15.00	20.00		9.50			0.00	694.50
17-Mar	Meeting in Altona					15.00	20.00				119	38.08	73.08
30-Mar	Meeting in Salem			95.00		12.00	21.00	45.00	10.00	35.00	280	89.60	307.60
31-Mar	Meeting in Salem				8.00	15.00	20.00		6.00		280	89.60	138.60
		475.00	55.00	215.00	8.00	57.00	81.00	45.00	25.50	35.00	679	217.28	1213.78