Microsoft Office Tutorials and References
In Depth Information
Session 1.1 Quick Check
Before continuing, you’ll save your workbook with a descriptive name.
To save the current workbook:
1. Click the File tab on the Ribbon to display Backstage view.
2. Click the Save command in the navigation bar. The Save As dialog box opens
because this is the first time you are saving this workbook.
You can click the Save
As command in the
navigation bar to save a
previously saved workbook
with a new filename, to
a different location, or in
another file format.
3. Navigate to the Excel1\Tutorial folder included with your Data Files.
Trouble? If you don’t have the starting Data Files, you need to get them before
you can proceed. Your instructor will either give you the Data Files or ask you to
obtain them from a specified location (such as a network drive). In either case,
make a backup copy of the Data Files before you start so that you will have
the original files available in case you need to start over. If you have any
questions about the Data Files, see your instructor or technical support person for
4. Verify that Excel Workbook appears in the Save as type box.
Trouble? If your computer is set up to show filename extensions, you will see the
Excel file extension .xlsx in the Save as type box as well.
5. Select Book1 in the File name box, and then type RipCity Digital Orders . The
default filename Book1 is replaced with the name you entered.
6. Click the Save button. The Save As dialog box closes and the workbook file is
saved with its descriptive filename.
So far, you have entered the customer order data. In the process, you worked with
rows and columns. In the next session, you’ll learn how to work with individual cells
and groups of cells. You will also add calculations to the worksheet to determine how
much revenue Amanda will generate from these orders.
Session 1.1 Quick Check
1. What are the two types of sheets used in a workbook?
2. List two ways of identifying the active cell in the worksheet.
3. What is the cell reference for the cell located in the fourth column and third row
of a worksheet?
4. What keyboard shortcut changes the active cell to cell A1?
5. What is text data?
6. What keys do you press to start a new line of text within a cell?
7. Cell A4 contains May 3, 2013; why doesn’t Excel consider this entry a text string?
8. Explain the difference between clearing a row and deleting a row.