Microsoft Office Tutorials and References

In Depth Information

**It Takes All Types**

Figure 2-7:

To complete

the second

part of the

formula,

type * and

select

cell B2.

Figure 2-8:

Click the

Enter

button, and

Excel

displays the

answer in

cell C2 while

the formula

appears in

the Formula

bar above.

Now comes the fun part: After creating a formula like the preceding one

that refers to the values in certain cells (rather than containing those values

itself), you can change the values in those cells, and Excel automatically

recalculates the formula, using these new values and displaying the updated

answer in the worksheet! Using the example shown in Figure 2-8, suppose

that you change the value in cell B2 from 100 to 50. The moment that you

complete this change in cell B2, Excel recalculates the formula and displays

the new answer, 1000, in cell C2.

If you want it, just point it out

The method of selecting the cells you use in a formula, rather than typing

their cell references, is
pointing.
On most devices on which youâ€™re running

Excel 2013, pointing is quicker than typing and certainly reduces the risk