Microsoft Office Tutorials and References
In Depth Information
Session 1.2
SAM Assessment and Training
Assess
If your instructor has chosen to use the full online version of SAM 2003 Assessment and
Training, you can go beyond the “just-in-time” training provided on the CD that accompa-
nies this text. Simply log in to your SAM account ( http://sam2003.course.com) to launch
any assigned training activities or exams that relate to the skills covered in this tutorial.
Lab Assignments
Reinforce
The New Perspectives Labs are designed to help you master some of the key concepts
and skills presented in this text. The steps for completing this Lab are located on
the Course Technology Web site. Log on to the Internet and use your Web browser
to go to the Student Online Companion for New Perspectives Office 2003 at
www.course.com/np/office2003 . Click the Lab Assignments link, and then navigate
to the assignments for this tutorial.
Spreadsheets
Quick Check Answers
Session 1.1
Review
1. cell
2. D2
3. Ctrl + Home
4. click the Sheet2 tab
5. a. value
b. text
c. value
d. text (there is no equal sign indicating a formula)
e. text
f. formula
g. text
6. Press the Alt + Enter keys to enter text on a new line within a cell.
7. =E5/E6
Session 1.2
1. An adjacent cell range is a rectangular block of cells. A non-adjacent cell range con-
sists of two or more separate adjacent ranges.
2. A5:F8
3. AutoSum
4. down
5. to the right
6. Double-click the sheet tab and then type the new name to replace the highlighted
sheet tab name.
7. Clearing a cell deletes the cell’s contents but does not affect the position of other
cells in the workbook. Deleting a cell removes the cell from the worksheet, and other
cells are shifted in the direction of the deleted cell.
8. Ctrl + ` (grave accent)
Search JabSto ::




Custom Search