Ndibaba corporation...ICT facilitator and sup[p[ort.
Open Excel to a blank worksheet.
Create a spreadsheet like the one below. Enter all the
numbers.
o Change
the formatting of the numbers to dollars.
o Make
the grid around the cells visible.
o Insert
the title “Monthly Budget” and center and merge it.
§ Change
the font to Baker Signet, size 18.
§ Make
the text white and the fill black.
o Insert
the subtitle “January 2005 – June 2005.”
§ Change
the font to Baker Signet, size 10
§ Make
text white and fill black.
§ Center
and merge it.
o Total
the expenses at the bottom of each month.
§ Widen
columns if necessary so numbers can be seen.
o Put
a dark border around the edges of the document.
o Change
the amount for gasoline in June from $60 to $70.
o Figure
out the average for each row. You must know the formula on your own!
o Center
and bold the headings (months and average)
§ Change
the font to BakerSignet on the headings
§ Bold
the headings in column A.
§ Change
the font to BakerSignet.
o Add
a header with your name.
Please tell the answer also
ReplyDelete