Center the Title of your spreadsheet across columns A-H. Change the font size of the title to 12 pts and bold.
Bold and center the following cell headings:Items, Jan, Feb, Mar, Apr, May, June, Item Total, Monthly Total, Monthly Income, What's Left for Fun, Percentage of Income Going to Expenses, Total Monthly Income, and Average Monthly Pocket Change.
AutoFit columns appropriately.(if you see ### this means your cell is not wide enough to fit information in)
Calculate the following (YOU MUST USE FORMULAS OR FUNCTIONS):
Calculate the total for each item in the Item Total column from January to June (H6:H12) using the appropriate function.
Calculate the total for each month's bill in the Monthly Total row (B13:G13) using the appropriate function.
Calculate the maximum expense for each month using the appropriate function. Enter the calculation in appropriate cells. (B15:G15)
Calculate the minimum expense for each month using the appropriate function. Enter the calculation in appropriate cells. (B16:G16)
Calculate the Total Monthly Income from Jan to June using the appropriate function. (H18)
Calculate What’s Left for Fun using the appropriate formula. (B21:G21) Tip: When putting formulas in excel you need to start with an = sign. This lets excel know it’s not just a number.
Calculate the Average Monthly Pocket Change using the appropriate function.(H21)
Calculate Percentage of Income Going to Expenses using the appropriate formula.(B23:G23)
Save the spreadsheet as Monthly Expenses.
Format the following cells:
Item Total column – commas and two decimal places.
Monthly Income row (including Total Monthly Income) – comma with no decimal places.
Maximum and Minimum rows – two decimal places.
What’s Left for Fun row, Average Monthly Pocket Change cell and the Monthly Total row – currency with two decimal places.
Percentage of Income Going to Expenses row – percent with two decimals.
Format all Monthly Expenses from Jan-Jun (excluding Item Total) to- two decimal places.
Create a 3-D Cluster Column chart that compares the monthly bills for January and June.   Tip: When selecting non-adjacent cells use the control key.
Include the title – January & June Comparison.
Insert a legend on the right side of the chart
Embed the chart within the current worksheet.
Place chart in range (A24:H36)
Change the font of the chart title to 12 pts. And bold.
Change the font size of the Category Axis to Size 10.
In row 2. Use the NOW function to enter the current date in cell H2. Format the date to look like the following example: 15-Mar-12.
Set up worksheet to print
Be sure the orientation is landscape and fit to one page.
Center the worksheet horizontally and vertically
Add your name  and section number to the Footer custom center section
Set the spreadsheet with gridlines and row and column headings.
Resave the file.  Check your work with the Completed Monthly Expense file below.
Close the workbook. Exit Excel. Submit completed Excel worksheet as an Excel File in the dropbox.