Page 50 - TP_Prime_v2.2_Class_6
P. 50
Step 3: Click on the Define Name command under the Defined Names group. The New Name
dialog box appears.
Step 4: Type the name and click on the OK button. The assigned name appears in the Name
box.
Prime (Ver. 2.2)-VI
48 Cell Range Selected
New Name Dialog Box Naming Cell Range
Now, we can use this name in place of the 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
the Enter key. Using Cell Reference
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 change.

