125
iNPuT
DATA
51
Car Purchase
12. Insert a footer that shows:
a. Center Secti on PAGE number
13. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
14. Carefully proofread your work for accuracy.
15. Save the spreadsheet as CAR PURCHASE.
16. Analyze the changes made to the data in the spreadsheet.
17. Set the Print Area to include all cells containing data in the spreadsheet.
18. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page.
19. Center the spreadsheet horizontally on the page.
20. Print a copy of the spreadsheet if required by your instructor.
NEW SKILL
ACTIVITY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
A
B
C
D
E
F
CAR PURCHASE SAVINGS CALCULATOR
Percentage Rate:
4.00%
Savings
Car Savings in Years
per
Month
1
2
3
4
5
50
75
100
125
150
175
200
225
250
275
300
325
350
375
400
425
450
475
500
For Evaluation Purposes Only