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

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents



Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net