budget plan

For the following items, you MUST use an Excel function. You cannot calculate the values and enter a number. Excel functions include SUM, AVERAGE, MIN, MAX, etc. You must choose the correct Excel function and then use it properly to get full credit.
Using an Excel function, calculate the average of each type of expense category for the months you have listed. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each expense category, using a function provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each month, then a grand total of all the months, using functions provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income. Use an absolute reference to reference the cell of the monthly income. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the monthly totals you have calculated to create your pie chart. Put the pie chart on its own worksheet labeled “Chart”. Please note, the chart values should be from the budget page of the worksheet. Do not copy the values into the new worksheet.
Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as ##### so make sure your columns are of the correct width for the data.
Check your spelling
Create a footer displaying the filename.
Save your completed file with the filename formatted as Excel_Budget_yourfirstname_yourlastname.xls. An Excel document should be uploaded to D2L.
I have included two (2) example budgets for you to review, Budget Example 1, Budget Exampe 2. These are from students from another section of this course. These are meant to be guides and not exemplars. Please note, even though these are PDFs, you are expected to upload a XLS.

Last Completed Projects