beautypg.com

Apple AppleWorks 5 : Mac OS User Manual

Page 162

background image

7-16

AppleWorks 5 User’s Manual

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 press Enter.

The formula contains the named cells Income and Expenses.

Example 2: Replacing named cells with cell references

This example shows you how to replace the named cells you defined in
Example 1 with cell references.

1. Select cell B3 and choose Replace Names from the

menu in the entry bar.

2. In the dialog box, note that Expenses and Income are suggested for replacement

with cell addresses. You want to replace them both, so click Replace.

The named cells are replaced with their corresponding cell addresses.