Annual Budget Part 2- after carefully preparing your budget it's time to get a job. For part 2 of this budget assignment you will have a full time job and earn minimum wage. Will you be able to afford your lifestyle? We shall see. Use formulas and/or functions and format text as directed.

1. Open the file that you completed in the first part of the Annual Budget assignment (it should be called annualbudget.xls).

2. Save this file as annualbudgetpart2.

3. Change the row title total to total expenses.

4. In cell A12 enter average expense. Bold this word.

5. Using the AVERAGE function, calculate the average expense for each month. The averages should appear in row 12. Click here for help.

6. In cell A14 type hourly wages.

7. In cell A15 type hours worked per month.

8. In cell A16 type earnings before taxes.

9. In cell A17 type earnings after taxes.

10. In cell A18 type earnings after expenses.

11. Bold the contents of cells A14 through A18.

12. Format the cells of column A to "wrap text". Click here for help.

13. Adjust the width of column A so that there are no more than two words per line.

14. Type 6.75 in cells B14 through M14. Format the cells in the hourly wages row as currency with two decimal places. Where did this number come from? Click here to find out. Need help? Click here for help.

15. Enter 160 in cells B15 through M15. This is the number of hours you will work each week (40 hours a week is considered full time work).

15. In the earnings before taxes row create a formula that calculates how much you earn each month (hourly wages multiplied by hours worked per month). Click here for help with formulas.

16. In the earnings after taxes row create a formula that shows how much you have left after taxes are deducted from your paycheck (the contents of the earnings before taxes row multiplied by .80).

17. The earnings after taxes amount is how much money you have to pay your bills each month. Change the hours worked for each month so that you make enough to pay your bills each month. Keep changing the number until you make enough money. The number of hours that you work each month will be different from one month to the next.

18. Calculate the earnings after taxes and expenses for each month using a formula. HINT: The formula should be earnings after taxes minus total expenses.

19. Total each row except for hourly wages and hours worked per month. The total should appear in column N.

20. Change all of the numbers to currency with two decimal places except for hours worked per month.

21. Change the font size of the spreadsheet to Arial, 9 point font.

22. Save your spreadsheet. Make sure that you are saving it as annualbudgetpart2.

Now, on to the graphs and charts.

1. Create a line graph that shows average expenses for each month. The X-axis (bottom of the graph) should show months. The Y-axis (left side of the graph) should show dollars.

2. Label the X-axis Months.

3. Label the Y-axis Dollars.

4. Title the graph "Average Expenses - your name". Create the graph on a new sheet.

5. Create a clustered column chart that shows total expenses and earnings after taxes and expenses for each month. The X-axis (bottom of the graph) should show months. The Y-axis (left side of the graph) should show dollars.

6. Title the graph "Earnings and Expenses - your name". Create the graph on a new sheet.

Print the following:

1. Your spreadsheet in landscape format, showing gridlines, on one page.
2. Your spreadsheet showing formulas in landscape format, showing gridlines.
3. Your line graph.
4. Your column chart.