Objective 10. Open and Save an Existing Workbook

When you start the Excel program, a new blank workbook with three worksheets displays. Individual worksheets may contain data for separate topics or for separate periods of time related to the workbook's data. Sometimes one worksheet summarizes information from the other worksheets.

Activity 1.19. Opening and Saving an Existing Workbook

Devin has asked all three volunteers to track the amount of gasoline and mileage for their vans by recording the number of miles traveled each time gasoline is purchased. The worksheets have been partially completed and now require editing. In this activity, you will open the workbook and save it in your chapter folder using a different name. The gas usage and mileage records for volunteers from the three restaurants are already entered and a summary sheet with a chart is included.

1.

Start Excel. From the menu bar, display the File menu, and then click Open. Alternatively, click the Open button on the Standard toolbar.

 

2.

In the displayed Open dialog box, click the Look in arrow, and then navigate to the student files that accompany this textbook. Click to select the file e01B_Gas_Usage, and then, in the lower right corner of the dialog box, click Open.

The workbook e01B_Gas_Usage displays. Alternatively, you can double-click a file name to open it. The workbook includes data already captured from gas receipts, including the number of gallons purchased and the total amounts printed on the receipts. Excel formulas have been inserted to calculate the total of all receipts. The data for one trip, on February 24, is missing.

 

   

3.

From the File menu, click Save As. In the displayed Save As dialog box, click the Save in arrow to view a list of the drives and folders available to you. Navigate to the drive on which you created your Excel Chapter 1 folder, and then double-click the folder name to display it in the Save in box. Compare your screen to Figure 1.71.

 


 

Figure 1.71.

 

4.

In the File name box, delete any existing text by selecting it and pressing the key, and then using your own first and last name, type 1B_Gas_Usage_Firstname_Lastname Be sure to include the underscore () instead of spaces between words.

Windows recognizes file names that use spaces between words, but some electronic file transfer programs do not. In this text, you will use underscores instead of spaces between words for your file names so you can be assured that your files will move easily if you need to transfer files on the Web.

 

5.

In the lower right corner of the Save As dialog box, click Save.

The file is saved in your chapter folder with the new name. The workbook redisplays, and the new name displays in the title bar.

 

[Page 653 (continued)]

Objective 11 Navigate and Rename Worksheets

Категории