The default setting for the number of worksheets in a workbook is three. You can add worksheets or delete worksheets. Each worksheet has a total of 16,777,216 cells (256 columns 3 65,536 rows). Using multiple worksheets in a workbook is frequently a logical approach to arranging data.
Activity 1.20. Navigating Among and Renaming the Worksheets in a Workbook
When you have more than one worksheet in a workbook, you can navigate (move) among worksheets by clicking the sheet tab. Sheet tabs, which identify each worksheet in a workbook, are located along the lower border of the worksheet window. When you have more worksheets in the workbook than can be displayed in the sheet tab area, use the four sheet tab scrolling buttons to move sheet tabs into and out of view.
Excel names the first worksheet in a workbook Sheet1 and each additional worksheet in orderSheet2, Sheet3, and so on. Most Excel users rename the worksheets with names that are more meaningful.
In this activity, you will navigate among four worksheetsthree contain data about the gas and mileage for each volunteer and the last worksheet summarizes the data in the first three. You will also rename the worksheets.
Along the bottom of the Excel window, point to and then click the Sheet2 tab. Compare your screen with Figure 1.72.
The second worksheet in the workbook displays and becomes the active worksheet. Sheet2 displays in bold.
In cell A1, notice the text Austin #2this worksheet contains data for the van used by the volunteer employee at the Austin #2 restaurant. Click the Sheet1 tab.
Point to the Sheet4 tab and right-click. On the displayed shortcut menu, click Rename. With Sheet4 selected, type Summary and then press .
Point to the Sheet1 tab and then double-click to select its name. Type Austin #1 and then press . Using either of the two methods you just practiced, rename Sheet2 to Austin #2 and Sheet3 to Dallas Compare your screen with Figure 1.73.
[Page 655 (continued)]
Objective 12 Enter Dates and Clear Formats
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
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
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