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 fi 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 fi nd that the formulas recalculate and return different values. These formulas all
depend on the initial value in cell B2, though.
Search JabSto ::




Custom Search