Load Microsoft Excel to create the following spreadsheet.
Create an imaginary monthly budget with budget categories in Column A and amounts in Column B. Be sure to include all expense categories and put some realistic numbers for each category. Use the SUM function to create a total at the bottom which adds up all the expenses in Column B. Add a percentage formula in Column C which takes each budget item as a percentage of the total. Copy the formula down. HINT: You will need to use an absolute cell reference for the denominator in your percentage formula so that it will be locked down on your total, and will not change as you copy the formula down.
Create a pie chart from the budget you created and place it in view, just to the right of your data.
Go back and edit your budget to add a budget item for savings.
Save the file and turn it in.