Chapter One Creating a Worksheet and an Embedded Chart
I Enter Data & Do Calculations
1. Type the title & subtitle in A1 & A2.
2. Highlight the area of A1 to H1 and click Merge & Center.
Similarly, merge and center for the sub-title.
3. Type the column titles as below.
4. Get column wider: move your mouse around B & C to get
a cross sign 
.
Double click on the cross sign.
Similarly, make columns C to G wide enough.
5. Type the row entries as below.
Also, make the column
A wide enough.
6. Copy or type the following to cells B4 to G8.
| 74029.35 | 92278.21 | 63081.74 | 84210.02 | 61644.26 | 89820.51 |
| 67286.06 | 83867.23 | 55076.48 | 55547.28 | 79779.02 | 84366.19 |
| 54704.39 | 66934.67 | 64581.66 | 28895.86 | 32690.37 | 64242.72 |
| 30623.99 | 58614.35 | 51486.46 | 36387.09 | 51642.55 | 40177.87 |
| 16692.14 | 24223.81 | 9492.91 | 17328.74 | 12305.85 | 21097.60 |
7. Click cell H4 and get the total of row 4 from AutoSum
8. Hold the special corner of H4 and drag down for the rest totals.
9. Click cell B9 and get the total of column B from AutoSum.
10. Hold the special corner of B9 and drag to left for the rest totals.
11. Rename the sheet to Lifetime Fundraising Summary.
12. Copy the sheet to Sheet2 and rename it as formula. Hold Ctrl + ~ to show formula on this sheet.
II. Format the worksheet:
1. Changing a Cell Style
2. Changing the Font
Changing the Font Color and Size (14) of a Cell Entry
3. Changing a cell style for column titles.
Highlight A3 to H3 / cell style / Heading 3.
4. Changing a cell style for row of total.
Highlight A9 to H9 / cell style / total.
5. Format Numbers in the Worksheet.
(a) Highlight B4 to H4 / $
(b) Highlight B5 to H8 / , Comma
(c) Highlight B9 to H9 / $
6. Add a Chart
Highlight A3 to G8 (Note that do not include totals)
Move the chart and change the shape until it locate at A11 to H23.
Save your file and send it to your instructor.