Page 42 - TP_Plus_v4_Class6
P. 42
2 Click on the Click on the Define 3
Formulas tab. Name command.
Select the range of cells to which 1
you want to assign a name.
4
Type the name.
Click on the 5
OK button.
Now, we can use this name in place of cell address in formulas.
CELL REFERENCING IN FORMULAS AND ITS TYPES
A cell reference is a cell address that can be used in a
formula to denote a specific cell. A formula may contain
reference of other cells. In such a case, the result of a
formula depends on the values in the referenced cells.
In case you make any change in the referenced cells, the
result will automatically be changed.
To see how this works:
Enter 10 in cell A1.
Now select cell A2 and type =A1*2, and press Enter key.
The value in cell A2 is 20. If you change the value in cell A1 from 10 to any value, the value in cell A2 will
also automatically change.
Cell references are especially helpful when you create complex formulas. There are three types of cell
references used in Excel: relative, absolute and mixed.
40 Plus (Ver. 4.0)-VI

