Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Naming Cells and Ranges
FIGURE 4.1 Use a Name for Cell G1
FIGURE 4.2 Naming a Cell in Excel
FIGURE 4.3 Use the Name
Tax
in the Formula
Now you can complete the operation (Enter) and either drag the result down or
double-click the lower right corner of cell F3 resulting in the tax calculation for all
cells in column F. See Figure 4.4.
One additional advantage of using the name concept is eliminating the use of the
absolute addressing concept. Another advantage is the fact that you don
t have to
search for the cell containing the tax rate of 15 percent. You can just type Tax (it is
Search JabSto ::




Custom Search