Create an Excel worksheet and chart as shown below. Save the worksheet with the name: Budget your own name. The final product should contain the appropriate functions and formulas. In addition, use absolute addressing where appropriate. Format as follows:

• Rename the sheet tab Semi-Annual Budget and delete the other sheets.
• Enter the worksheet title in cell A1 and merge and center it using cells A1-I1.
• You can use any font but increase the font size of the worksheet title; any size just bigger.
• Boldface column headings, row headings and total headings.
• Cells A1-I1 should be formatted with a thick box border.
• Cells A1-I1 should be formatted with a background color (you can use any color).
• The row headings should be left-aligned.
• The column headings should be centered.
• The column heading in cell I3 should be wrapped to two lines.
• Cells A12-I12 should include a top and bottom border.
• Cells A17-H18 should be formatted with a background color (use the same color as above).
• The numbers in columns B-H should be formatted with a floating $ and two decimal places.
• Increase the height of row 13 relative to the other rows.
• The percentages should be formatted with one decimal place.
• Format, position and size the chart as shown.
• Do not include a chart title.
• The data labels on the chart should include only the percentages and be positioned outside each slice showing the leader lines.
• Boldface the data labels and the legend and position the legend to the right of the chart as shown.

B D E F G H Semi-Annual Budget 1 2 3 Expense Category 4 Rent 5 Gas 6 Food 7 Phone 8 Miscellaneous 9 Auto Repair 10 Auto Insurance 11 Credit Card January $450.00 $275.00 $350.00 $75.00 $200.00 $75.00 $100.00 $200.00 February $450.00 $220.00 $300.00 $100.00 $200.00 $0.00 $100.00 $200.00 $1,570.00 March $450.00 $220.00 $300.00 $100.00 $200.00 $0.00 $100.00 $200.00 $1,570.00 April $450.00 $275.00 $375.00 $70.00 $200.00 $200.00 $100.00 $200.00 May $450.00 $250.00 $300.00 $130.00 $200.00 $150.00 $100.00 $200.00 $1,780.00 June Total $450.00 $2,700.00 $300.00 $1,540.00 $300.00 51,925.00 $100.00 $575.00 $200.00 $1,200.00 $0.00 $425.00 $100.00 $600.00 $200.00 $1,200.00 $1,650.00 $10,165.00 Percentage of Total Expenses 26.6% 15.2% 18.9% 5.7% 11.8% 4.2% 5.9% 11.8% 12 Total $1,725.00 $1,870.00 100.0% 13 14 15 16 17 Monthly Income 18 Funds Left 19 20 21 22 23 Minimum Semi Annual Expenditure $425.00 Maximum Semi-Annual Expenditure $2,700.00 Average Semi-Annual Expenditure $1.270.63 $2.200.00 $2.500.00 $13.100.00 $420.00 $850.00 $2.935.00 $2,000.00 $2,000.00 $275.00 $430.00 11.8 $2,200.00 $630.00 $2,200.00 $330.00 5.9% 26.6% Rent 11.8% 25 26 27 28 29 wood Phone Miscellaneous Auto Repair Auto Insurance Credit Card 5.7% 15.2% Semi-Annual Budget B D E F G H Semi-Annual Budget 1 2 3 Expense Category 4 Rent 5 Gas 6 Food 7 Phone 8 Miscellaneous 9 Auto Repair 10 Auto Insurance 11 Credit Card January $450.00 $275.00 $350.00 $75.00 $200.00 $75.00 $100.00 $200.00 February $450.00 $220.00 $300.00 $100.00 $200.00 $0.00 $100.00 $200.00 $1,570.00 March $450.00 $220.00 $300.00 $100.00 $200.00 $0.00 $100.00 $200.00 $1,570.00 April $450.00 $275.00 $375.00 $70.00 $200.00 $200.00 $100.00 $200.00 May $450.00 $250.00 $300.00 $130.00 $200.00 $150.00 $100.00 $200.00 $1,780.00 June Total $450.00 $2,700.00 $300.00 $1,540.00 $300.00 51,925.00 $100.00 $575.00 $200.00 $1,200.00 $0.00 $425.00 $100.00 $600.00 $200.00 $1,200.00 $1,650.00 $10,165.00 Percentage of Total Expenses 26.6% 15.2% 18.9% 5.7% 11.8% 4.2% 5.9% 11.8% 12 Total $1,725.00 $1,870.00 100.0% 13 14 15 16 17 Monthly Income 18 Funds Left 19 20 21 22 23 Minimum Semi Annual Expenditure $425.00 Maximum Semi-Annual Expenditure $2,700.00 Average Semi-Annual Expenditure $1.270.63 $2.200.00 $2.500.00 $13.100.00 $420.00 $850.00 $2.935.00 $2,000.00 $2,000.00 $275.00 $430.00 11.8 $2,200.00 $630.00 $2,200.00 $330.00 5.9% 26.6% Rent 11.8% 25 26 27 28 29 wood Phone Miscellaneous Auto Repair Auto Insurance Credit Card 5.7% 15.2% Semi-Annual Budget