Data Analysis with Microsoft Excel: Updated for Office 2007

52 Excel

To create range names for the service station data:

1 Select the range A1:D11.

2 Click the Create from Selection button located in the Defi ned Names

group on the Formulas tab.

Excel will create range names based on where you have entered the

data labels. In this case, you’ll use the labels you entered in the top

row as the basis for the range names.

3 Verify that the Top row checkbox is selected as shown in

Figure 2-12.

Figure 2-12

Creating

range names

from a

selection

4 Click OK.

Four range names have been created for you: Station, Gas, Other,

and Total. You can use Excel’s Name Box to select those ranges

automatically.

To select the Total range:

1 Click the Name Box (the drop-down list box) located directly above

and to the left of the worksheet’s row and column headers.

2 Click Total from the Name Box.

The cell range D2:D11 is automatically selected. See Figure 2-13.