Objective 11. Navigate and Rename Worksheets

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.

1.

Along the bottom of the Excel window, point to and then click the Sheet2 tab. Compare your screen with Figure 1.72.
 

Figure 1.72.


The second worksheet in the workbook displays and becomes the active worksheet. Sheet2 displays in bold.
 

2.

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.

The first worksheet in the workbook becomes the active worksheet, and cell A1, which is formatted with a yellow background, displays Austin #1.
 

 

3.

Point to the Sheet4 tab and right-click. On the displayed shortcut menu, click Rename. With Sheet4 selected, type Summary and then press .
 

4.

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.
 

Figure 1.73.

 


[Page 655 (continued)]

Objective 12 Enter Dates and Clear Formats

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