Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 149)

Spreadsheet 7-15
Example 1: Using cell names in a formula
This example shows you how to name two cells and use the names in
a formula.
1. Open a new, blank spreadsheet document, and then type Income , Expenses ,
and Profit in cells A1, A2, and A3, respectively.
2. Format column B for currency.
Select the entire column, click on the Default button bar (or choose
Number from the Format menu, select Currency, and then click OK).
3. Select cell B1 and choose Define Name from the menu in the entry bar.
4. Click Define to accept the suggested name, Income .
5. Select cell B2 and choose Define Name from the menu in the entry bar.
6. Click Define to accept the suggested name, Expenses .
7. Cells B1 and B2 are now named Income and Expenses.
8. Type 1000 and 800 in cells B1 and B2, respectively.
9. Select cell B3 and type an equal sign (=).
10. Choose Income from the menu in the entry bar and type a minus sign ( - ).
11. Choose Expenses from the menu in the entry bar and then press Enter.
Cell name appears here