84
1. Adjust page
scaling so that
multi ple page
data can print on
one page.
2. Remove
comments from
cells.
T
he following acti vity provides additi onal informati on about the original
13 states and illustrates how spreadsheets can be adjusted to fi t on a
designated number of pages. This acti vity expands on the ORIGINAL 13 STATES
spreadsheet created in Acti vity 22.
1. Open the fi le ORIGINAL 13 STATES previously created in Acti vity 22.
Unless otherwise stated, the font should be 10 point Arial.
2. Change the Acti vity # in the left secti on of the header to Acti vity 36 and the
acti vity name in the center secti on of the header to ORIGINAL 13 STATES 2.
3. Type the data in columns E, F, and G as shown.
4. Use AutoFit to adjust the width of columns E and F.
5. Format the width of column G to 18.0 and center align.
6. Format cells G4 G16 as dates showing mm/dd/yyyy. Example: "12/25/2011."
7. Bold and center align cells E3 G3.
8. Insert a column between column B, ABBREVIATION, and column C, LICENSE
PLATE SLOGAN. Then move the DATE OF STATEHOOD column to the newly
created column. The DATE OF STATEHOOD should now be in column C.
9. Select cells A3 G3 and format the shading color to light blue.
10. Select cells A4 A16 and remove the Comments.
11. Carefully proofread your work for accuracy.
12. Save the spreadsheet as ORIGINAL 13 STATES 2.
13. Analyze the changes made to the data in the spreadsheet.
14. Set the Print Area to include all cells containing data in the spreadsheet.
15. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page. Adjust the scaling to 65% of normal size. Set the Page Orientati on to
Landscape.
16. Print a copy of the spreadsheet if required by your instructor.
36
Original 13 States 2
NEW SKILL
NEW SKILL
ACTIVITY
For Evaluation Purposes Only