Microsoft Office Tutorials and References
In Depth Information
As you may have noticed while you were working in Print Preview and the Page Setup
dialog box, there are a lot of options for choosing what to print and how to print. You’ll
examine more of these options in Tutorial 3. For now, you can switch the Orders work-
sheet back to Normal view and save and then close the file.
To complete your work:
1. Press the Ctrl +` (grave accent) keys to switch the worksheet back to Normal view. The key-
board shortcut Ctrl + ` (grave accent) works as a toggle, so you can display or hide the for-
mulas by pressing this combination of keys.
2. Save your changes to the Dalton workbook, and then close it.
You give Sandra the hard copy of the Dalton workbook. If she needs to add new infor-
mation to the workbook or if she needs you to make further changes to the structure of the
workbook, she’ll contact you.
Session 1.2 Quick Check
1. Describe the two types of cell ranges in Excel.
2. How do you write the cell reference for the rectangular group of cells that extends
from cell A5 through cell F8?
3. The button provides a quick way to enter the SUM function.
4. When you insert a new row into a worksheet, the existing rows are shifted
5. When you insert a new column into a worksheet, the existing columns are shifted
6. How do you change the name of a worksheet?
7. How does clearing a cell differ from deleting a cell?
8. What keyboard shortcut do you press to display the worksheet formulas?
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
In this tutorial, you learned the basics of spreadsheets and Excel. You learned about the
major components of the Excel window. You also learned how to navigate within a work-
sheet and between worksheets in an Excel workbook. You learned how to enter text,
dates, values, and formulas into a worksheet and were introduced to functions using the
AutoSum button. Within the workbook, you practiced selecting and moving cell ranges.
You saw how to insert new rows and columns into a workbook and how to modify the
size of a column or row. You learned how to create new worksheets, rename them, and
move them around the workbook. You learned how to check the spelling in a workbook,
and finally, you learned how to print the contents of a workbook in different orientations
and how to print the formulas in that workbook.