Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 39

EXCEL TIPS

If you want to create a geometric sequence of numbers, drag the

fi ll handle with your right mouse button and then select Growth

Trend from the pop-up menu.

If you want to create a customized sequence of numbers or

dates, drag the fi ll handle with your right mouse button and

select Series... from the pop-up menu. Fill in details about

your customized series in the Series dialog box.

With the service station numbers entered, you can add the rest of the sales

fi gures to complete the data set.

To fi nish entering data:

1 Select the range B4:C10.

2 With B4 the active cell, start typing in the remaining values, using

Table 2-1 as your guide.

Note that when you’re entering data into a selected range, pressing

the Tab key at the end of the range moves you to the next row.

3 Click cell A1 to remove the selection.

The completed worksheet should appear as shown in Figure 2-3.

•

•

Figure 2-3

The

completed
service
station
data