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

Категории