Ineed help with the parts that arent hilighted
ted 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 13 should be wrapped to two lines. Cells A12-112 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. Hi C D Semi-Annual Budget 1 Percentage of Total Expenses Total Agril $450 00 June 3 Expense Category May $450.00 $250.00 January February $45000 March $450 00 $2,700.00 $1,540.00 $1,925.00 5575.00 26.6% S450.00 4 Rent $450 00 15.2% 5300 00 5300 00 $100.00 $200 00 $220.00 $275.00 S375.00 $70.00 $300 00 S200 00 $100 00 $200 00 s Gas $275 00 $220 00 $300.00 S100.00 $200 00 S0.00 18.9 % S300 00 $350 00 $300 00 $100.00 $200 00 50 00 6 Food 5.7% S130.00 $200.00 $15000 7 Phone 8 Miscellaneous 9 Auto Repair S75.00 $200 00 $75.00 $100,00 $20000 11.8% $1,200.00 $425.00 $600.00 $1,200 00 42% S0.00 S100.00 $200 00 5.9% $100 00 $200 00 $10000 $100.00 $200 00 10 Auto Insurance 11a% $200 00 11 Credit Card 100.0% $1.650.00 $10.165.00 SL780.00 $1.570.00 $1870.00 $1.570.00 $1.725.00 12 Total Minimum Semi-Annual Expenditure Maximam Semi-Annual Expenditure Average Semi Annual Expenditure $425.00 $2,700.00 13 $1.270.63 14 15 52.500.00 $13.100.00 $2.915.00 $2.200.00 $330.00 16 $2.200.00 5630.00 $2,200.00 $420.00 $2,000.00 $2.000.00 17 Monthly Income S850.00 $430.00 $275.00 18 Funds Let 19 24% 20 21 eod 42% 22 one 23 24 25 WMsoan Aute Bepair 26 27 13.2% oedt Card 28 29 Semi-Annual Budget Show transcribed image text ted 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 13 should be wrapped to two lines. Cells A12-112 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. Hi C D Semi-Annual Budget 1 Percentage of Total Expenses Total Agril $450 00 June 3 Expense Category May $450.00 $250.00 January February $45000 March $450 00 $2,700.00 $1,540.00 $1,925.00 5575.00 26.6% S450.00 4 Rent $450 00 15.2% 5300 00 5300 00 $100.00 $200 00 $220.00 $275.00 S375.00 $70.00 $300 00 S200 00 $100 00 $200 00 s Gas $275 00 $220 00 $300.00 S100.00 $200 00 S0.00 18.9 % S300 00 $350 00 $300 00 $100.00 $200 00 50 00 6 Food 5.7% S130.00 $200.00 $15000 7 Phone 8 Miscellaneous 9 Auto Repair S75.00 $200 00 $75.00 $100,00 $20000 11.8% $1,200.00 $425.00 $600.00 $1,200 00 42% S0.00 S100.00 $200 00 5.9% $100 00 $200 00 $10000 $100.00 $200 00 10 Auto Insurance 11a% $200 00 11 Credit Card 100.0% $1.650.00 $10.165.00 SL780.00 $1.570.00 $1870.00 $1.570.00 $1.725.00 12 Total Minimum Semi-Annual Expenditure Maximam Semi-Annual Expenditure Average Semi Annual Expenditure $425.00 $2,700.00 13 $1.270.63 14 15 52.500.00 $13.100.00 $2.915.00 $2.200.00 $330.00 16 $2.200.00 5630.00 $2,200.00 $420.00 $2,000.00 $2.000.00 17 Monthly Income S850.00 $430.00 $275.00 18 Funds Let 19 24% 20 21 eod 42% 22 one 23 24 25 WMsoan Aute Bepair 26 27 13.2% oedt Card 28 29 Semi-Annual Budget
Expert Answer
Answer to ted with a background color (you can use any color) The row headings should be left-aligned The column headings should b…