Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 46 - 2620_Birla Open Mind C-6
P. 46

    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.

                      44  Premium Edition-VI

| 41 42 43 44 45 46 47 48 49 50 51 |