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 f
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 : Excel Assignment [Compatibility Mode] – Word Sign in E – X
File Home Insert Design Layout References Mailings Review View Q Tell me what you want to do Q Share
A fin A v – 1- 1- – – – I) Find v
E E A i t: * – v j v v A 0- v 2- v 3 – v GE 95 fi
D a T’mE- New Ro h A A A3 – z- – – Ll ‘ll AaBchl AaBbC AaBchI AaBch] AaBchD AaBbC AaBchI AaBchl ab R I
14:1le v “8C 8p ace
Paste VFormat Painter B I g v abs x2 x2 a}? v A v g g g g $5 v é) v _ v Emphasis Headingl ‘ll Normal Strong Subtitle Title ‘ll No Spac… Subtle Em… 7 [g Select’
Clipboard F. Font F. Paragraph F. Styles F. Editing A
1 Semi-Annual Budget I A
Percentage of
3 Expense Category January February March April May June total total Expenses
4 Rent 5450.00 5450.00 5450.00 5450.00 5450.00 5450.00 52,700.00 26.6“
S Gas 5275.00 5220.00 522000 5275.00 5250.00 5300.00 51,540.00 15.2”
6 Food 5350.00 5300.00 530000 5375.00 5300.00 5300.00 51,92500 18.936
7 Phone 575 00 5100 00 5100 00 57000 5130 00 510000 5575 00 5.736
8 Miscellaneous 5200.00 520000 520000 520000 5200.00 520000 51100400 11.876
9 Auto Repair 575.00 50.00 5000 5200.00 5150.00 50.00 5425.00 4.25
10 Autoimmune 510000 510000 510000 5100.00 510000 510000 56m<00 5.9”
11 LAWN-M
1: Total Suzsm $1,570.00 $1,570.00 smrom smaom $1,650.00 $10,165.00 100.096
13 Minimum SemioAnnuol Expenditure $425.00
14 Maximum Semi-Annual Expenditue $2,700.00
15 Average Semi-Annual Expenditure $1,270.63
16
17 my Mm WM 5mm SIM 52.241)“ szzoom $2500.00 513.111)“
13 Finds left 5275“ $430.00 $6301!) $330.00 5420“ 5850“ 52.935.”
19 u.“
143 ”h 7 ” – more “m
41 nae:
“G 4,11; . ufood
54 \ i iPt’one
75 “fl , \ qudbneous
26 some new:
37 name mama
