119
49
NBAŽ Standings 2
e. In cell E35, type
=$B$35-B35
ˇ Use the AutoFill feature to copy the formula down for the remaining teams in
the Pacifi c Division.
f. In cell E42, type
=$B$42-B42
ˇ Use the AutoFill feature to copy the formula down for the remaining teams in
the Southwest Division.
5. Format column E as accounti ng displaying 0 decimal places and no symbol.
6. Insert a header that shows:
a. Left Secti on
Acti vity 49-Student Name
b. Center Secti on NBA STANDINGS 2
c. Right Secti on
Current Date
7. Insert a footer that shows:
a. Center Secti on PAGE number
8. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
9. Carefully proofread your work for accuracy.
10. Save the spreadsheet as NBA STANDINGS 2.
11. Analyze the changes made to the data in the spreadsheet.
12. Set the Print Area to include all cells containing data in the spreadsheet.
13. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page.
14. Print a copy of the spreadsheet if required by your instructor.
ACTIVITY
For Evaluation Purposes Only