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
Search JabSto ::




Custom Search