40
T
he process of researching and selecti ng a college to att end can be both
daunti ng and exciti ng at the same ti me, and may very well be the most
important lifeti me task you will undertake. The Web is a powerful tool that
provides informati on about colleges and streamlines the applicati on process. A
criti cal part of getti
ng into college is to take one of the standardized admission
tests, such as the Scholasti c Apti tude Test (SAT) and the American College Test
(ACT). Four steps to be followed are: 1) research your college opti ons, 2) stay on
schedule (adhere to the ti melines), 3) take the tests, and 4) apply to schools.
The following acti vity illustrates how spreadsheets can be used to list
informati on about the colleges researched.
1. Format text
directi on.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial
2. Type the data as shown.
3. Bold row 3.
4. Bold cell A1 and change the font size to 20 point.
5. Format the width of column A to 30.0 and left align.
6. Format the width of column B to 6.0 and center align.
7. Format the width of column C to 10.0 and right align.
8. Format the width of columns D F to 20.0 as numbers displaying 0 decimal
places with a comma separator and right align.
9. Format the headings in columns D F so the text orientati on is set to 45
degrees.
10. Insert a header that shows:
a. Left Secti on
Acti vity 18-Student Name
b. Center Secti on TOP 15 COLLEGES IN THE U.S.
c. Right Secti on
Current Date
11. Insert a footer that shows:
a. Center Secti on PAGE number
12. Carefully proofread your work for accuracy.
13. Save the spreadsheet as COLLEGES.
14. Analyze the changes made to the data in the spreadsheet.
15. Set the Print Area to include all cells containing data in the spreadsheet.
16. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page. Set the Page Orientati on to Landscape.
17. Print a copy of the spreadsheet if required by your instructor.
18
Colleges
NEW SKILL
ACTIVITY
For Evaluation Purposes Only