Integrate Excel
and Word Skills
project
Excel Worksheet
1
JOB
1. Create a worksheet showing the budget for the Software Mastery Training Series, as
shown in the spreadsheet on the following page. Save the file as EX-job1.
2. Prepare the worksheet heading as follows.
a. B1—Merge and center over columns B-H. Format bold, Antique Olive, 14-point
font, and Indigo font color.
b. B2—Merge and center over columns B-H, bold, Indigo font color.
c. D3—Revised:, bold, Indigo font color.
d. E3—Enter date function; bold, Indigo font color, format with 3/14/01 date style.
e. A1—Insert clip art; size to fill the range A1:A3. (Hint: Search for computers.)
f. Row 1—Change row height to 37.50 and center the text in the row vertically.
g. Row 3—Change row height to 24.00.
h. Apply a cell border around A1:H3. Choose indigo border with yellow shading.
3. Insert a new row as the fourth item in the Salaries category. Select A17:C17 and
move to the new row. Indent A10, like the three other salary categories above.
Move C10 to B10. Delete the blank row left when the Staff category was moved.
Project
Integrate Excel and Word Skills
Excel
EX-72
Your position as an assistant to Derek Bradberry, Training
Director of The Bookstore, Inc., will allow you to showcase
your Word and Excel skills. A needs assessment recently completed by Mr. Bradberry
revealed the need for staff members to master their software to increase efficiency in
completing administrative tasks. Your responsibilities include preparing the budget for the
Software Mastery Training Series, preparing a memo with the column chart you prepared
displaying the budgeted salaries, designing a worksheet template for the training series,
preparing the training design sheet, creating customer labels for the training diskettes, and
preparing a Web page.
overview
(continued)
Project
Integrate Excel and Word Skills
Excel
EX-73
4. Enter a formula in C11 to compute total benefits (15% of total salary). (Hint:
Reference the percent entered in A23.)
5. Enter a formula in C10 t