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. |
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. |
5. |
In the lower right corner of the Save As dialog box, click Save. |
[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