Datasheet

113
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
You can open the calculator from an Excel toolbar button. Right-click
in the toolbar area, click Customize, and click the Commands tab; in the
Categories list, click Tools; in the Commands list, drag Custom (the one
with the calculator icon) to your toolbar. Read more about toolbars and
buttons in Chapter 21.
About cell references
A cell reference is the cell’s address on the worksheet in terms of its column
letter and row number. You can tell what any cell’s reference is by either
looking at the row and column that intersect at the cell or by selecting
the cell and looking at the Name box (see Figure 4.7).
Figure 4.7. The Name box shows the selected cell address or name.
If you click in the upper-left corner of the worksheet, the Name box
reads A1, which is that cell’s address: the combination of the column let-
ter, which is A, and the row number, which is 1.
Name box
Inside Scoop
You can make the calculator much more high-tech by choosing View

Scientific (I leave it to you to understand the higher-level mathematics avail-
able there). By the way, if you want to do a quick square root, it’s on the small
Standard calculator, but not on the Scientific calculator.
Inside
Scoop
Inside Scoop
To reference an entire column, use the column letter, as in B:B for column B. To
reference several columns, use the first and last column letters, as in B:D. Do
the same to reference entire rows.
Inside
Scoop
09_763217 ch04.qxp 1/18/06 11:23 PM Page 113