Excel It! 2nd Edition Page 22

dmunds.com provides new and used vehicle prices, a database of nati onal
and regional incenti ves and rebates, vehicle test drive reviews, and ti ps and

advice on all aspects of car purchasing and ownership. Its "True Market Value"
pricing tools provide the esti mated average price consumers are paying when
buying new vehicles and esti mates of the actual purchase prices for used
vehicles.
In 2005, Edmunds.com launched Inside Line, a free online magazine that
provides automoti ve enthusiasts with informati ve videos, photos, blogs, news
arti cles, discussion boards, and road tests. Carspace.com, a social networking
site for car enthusiasts, was launched by Edmunds.com in 2006.
The following acti vity illustrates how spreadsheets can be used to chart the
top 25 most popular vehicles researched at Edmunds.com in May 2010, by
search popularity and also indicates the esti mated miles per gallon (mpg) of
each vehicle.

1. Use the AutoFill

feature to

complete a

number sequence

in a spreadsheet.

1. Create a NEW spreadsheet.

Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cell A2 and A3 and change the font size to 20 point.
4. Bold rows 6 and 7.

5. Use the AutoFill feature to automati cally complete the series of POSITION

numbers. To do this, select cells A9 A10. While the cells are selected, click
the bott om right-hand corner of cell A10 unti l the mouse pointer changes to a
"+" sign. Now drag the mouse pointer down to cell A33 and release the mouse
butt on. The cells should now be fi lled to complete the number sequence for
cells A9 A33.

6. Format the width of column A to 12.0 and left align.

7. Center align cells A7 A33.

8. Format the width of columns B and C to 15.0 and left align.
9. Format the width of column D to 15.0 and center align.

10. Carefully proofread your work for accuracy.

11. Save the spreadsheet as AUTOMOBILE RESEARCH.

Automobile Research

NEW SKILL

ACTIVITY

For Evaluation Purposes Only