Excel It! 2nd Edition Page 105

1. Insert WordArt in

a spreadsheet.

2. Edit and format

WordArt.

special thing that every teenager looks forward to is obtaining a driver's
license and driving a new car. Auto manufacturers have created lower-

priced cars that help to make the dream of new car ownership a reality for
the teen market. Edmunds.com, an informati onal Web site designed for car
buyers, publishes various lists of Consumer Favorites, such as Best Economy
Cars, Best Family Cars, Best Cars for College Students, and others.
In this acti vity, you will be entering Edmunds.com's Best Cars for College
Students picks for 2010 into a spreadsheet. You will enhance the appearance
of the spreadsheet by using WordArt.

1. Create a NEW spreadsheet.

Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown. Be sure to enter the data in the correct cells.
3. Format the width of column A to 16.0 and left align.
4. Format the width of column B to 30.0 and left align.

5. Format the width of columns C and D to 16.0 and right align.
6. Format cells C9 D18 as currency displaying 0 decimal places and the $ symbol.

7. Change the font size of cells A6 D18 to 16 point.

8. Insert a WordArt image similar to the one shown in the Acti vity 41 Data

Spreadsheet. Edit the WordArt text to read "Best Cars for College Students -
2010" and change the font size to 24. Select a font of your choice. Place the
WordArt image so it is centered above the data entered in columns A D.

9. Insert a header that shows:

a. Left Secti on

Acti vity 41-Student Name

b. Center Secti on TEEN CARS

c. Right Secti on

Current Date

10. Insert a footer that shows:

a. Center Secti on PAGE number

11. Carefully proofread your work for accuracy.

12. Save the spreadsheet as TEEN CARS.
13. Analyze the changes made to the data in the spreadsheet.

Teen Cars

NEW SKILL

ACTIVITY

For Evaluation Purposes Only