Page 84 - PlusGPT_V2.1_C7_Flipbook
P. 84
Perform the following steps to assign a name to a cell range:
Step 1: Select the range of cells to which you want to
assign a name.
Step 2: Click on the Formulas tab from the Ribbon.
Step 3: Click on the Define Name command under the
Define Name 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. Cell range selected
New Name dialog box Naming cell range
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 cases, 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 then 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 change.
Using cell reference After changing value
Cell references are especially helpful in case of complex formulas. There are three types of cell
references used in Excel: relative, absolute and mixed.
Relative References
By default, all cell references are relative references. When copied across multiple cells, they change
based on the relative position of rows and columns. When a formula that possesses a relative
reference is copied from one cell to another cell, the value of the relative references in the copied cell
also changes.
82 Premium Edition-VII

