Microsoft Office Tutorials and References

In Depth Information

**Entering the sales data**

FIGURE 12.5

Your worksheet, after entering the column headings and month names

Entering the sales data

Next, you provide the sales projection numbers in column B. Assume that January’s sales

are projected to be $50,000, and that sales will increase by 3.5 percent in each subsequent

month.

1.
Move the cell pointer to B2 and type
50000
, the projected sales for January.
You

could type a dollar sign and comma to make the number more legible, but you do

the number formatting a bit later.

2.
To enter a formula to calculate the projected sales for February, move to cell

B3 and type the following:
=B2*103.5%. When you press Enter, the cell displays

51750. The formula returns the contents of cell B2, multiplied by 103.5%. In other

words, February sales are projected to be 103.5% of the January sales — a 3.5%

increase.

3.
The projected sales for subsequent months use a similar formula,
but rather

than retype the formula for each cell in column B, take advantage of the Auto

Fill feature.
Make sure that cell B3 is selected. Click the cell’s ﬁ fill handle, drag

down to cell B13, and release the mouse button.

At this point, your worksheet should resemble the one shown in Figure 12.6. Keep in mind

that, except for cell B2, the values in column B are calculated
with formulas.
To

demonstrate, try changing the projected sales value for the initial month, January (in cell B2).

You’ fill ﬁ nd that the formulas recalculate and return different values. These formulas all

depend on the initial value in cell B2, though.