137
1. Format a business
lett er using
Microsoft Word.
2. Insert an Excel
worksheet into a
Word document.
A
ssume that you are the Secretary of the Senior Class. One of your
responsibiliti es is to keep students informed about upcoming events. The
Athleti cs Department has once again asked each class to involve students in
the annual Pep Rally just before the annual Thanksgiving Day football game
to get the team "fi red up and ready for the big rivalry game." You need to
inform each member of your class on the budget for the rally. You are asked to
prepare a lett er addressed to each member of your class.
The following acti vity illustrates how a Microsoft ExcelŽ spreadsheet can be
integrated with a Microsoft WordŽ document.
55
Pep Rally Expenses
1. Create a NEW document in Microsoft Word. Type the document in Times New
Roman font and with a font size of 12 point.
2. Set the left and right margins to 1 inch, top to 1.5 inches, and bott om to .5
inches.
3. Type the text shown in the business lett er provided in
Figure 55-1
. Stop typing
when you reach the end of the fi rst paragraph in the body of the lett er.
4. Create and insert the Microsoft Excel Worksheet located under the fi rst
paragraph in the lett er by following the instructi ons provided below.
Instructions for creating the Microsoft Excel Worksheet inside the letter:
a. Positi on the cursor two lines below the fi rst paragraph in the lett er.
b. From the "Insert" menu or tab, choose "Object" then "Microsoft Excel
Worksheet."
c. Type the data as shown in the spreadsheet provided.
Unless otherwise stated, the font should be set to 10 point Arial.
d. Bold cell A1 and change the font size to 14 point.
e. Bold and underline cells A3 C3.
f. Format the width of column A to 35.0.
g. Format the width of column B to 25.0 and center align.
h. Format the width of column C to 10.0 and center align.
i. Format cells C4 C8 as currency displaying 0 decimal places and the $ symbol.
j. Enter formulas to compute the totals for columns B and C.
k. Bold cells A8 C8.
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only