Page 20 - iPlus_Ver_2.0_class_8
P. 20

By Using the Shift Key

                  To select a range by using the Shift key, follow the given steps:

                                                                                                      2  Press and
                                                                                                      hold the Shift
                      1  Click on                                                                     key and click
                     the first cell                                                                   on the last
                     from which                                                                       cell up to
                     you want                                                                         which you
                     to start the                                                                     want to make
                     range.                                                                           the selection.


                  When the Shift key is released. The range gets selected.
                  Naming a Cell Range

                  Excel allows us to assign a name to a cell range. This name can be used in place of cell address
                  in formulas. To assign a name to a cell range, follow the given steps:

                      2  Click on the Formulas tab.     3  Click on the Define Name command.       4  Type the name.

















                                                                                          5  Click on the OK button.



                                                     1  Select the range of cells to which
                                                    you want to assign a name.















                  Now, we can use this name in place of the cell address in formulas.


                   i +  CELL REFERENCING IN FORMULAS AND ITS TYPES

                  A cell reference refers to a cell or a range of cells on a worksheet that can be used to find the
                  values or data. The main benefit of using a cell reference is when the data present in referenced
                  cell(s)  in another  worksheet  changes,  a  value  returned  by  the  cell reference  is automatically
                  updated.


                    18
                         iPlus (Ver. 2.0)-VIII
   15   16   17   18   19   20   21   22   23   24   25