Page 24 - Chinmaya_C6_flipbook
P. 24

ENTER FORMULA IN THE FORMULA BAR
                                                                     Select  the  cell and  enter  the  formula in  the

                                                                     Formula bar after typing an equal to sign. Now
                                                                     press the Enter key to see the result.



                                                                                        Life Skills & Values
                                                                         “Always Enter a formula as per
                                                                         BODMAS rule for accurate result.”
                                                                                              -Mr. Techie







                             CELL RANGE

                  A group of selected cells is called a cell range. The selected cells should be in continuation to form
                  a range. Cell range is used to perform a calculation on multiple cells. The address of a range is

                  created by using the starting and the ending cell addresses separated by a colon (:) sign. For
                  example, if we have selected the cells from B2 to E4 then the address of the range will be B2:E4.


                  SELECTING A CELL RANGE
                  We can select a range by using the mouse and by using
                  the Shift key.



                  By using the mouse
                  Click in the first cell from which you want to start the
                  range, then press and hold the left mouse button and

                  drag the mouse diagonally to select the desired range.
                  Now release the mouse button.


                  By using the Shift key

                  Click in the first cell from which you want to start the range, then press and hold the Shift key
                  down from the keyboard and click on the last cell up to which you want to make a selection. Now
                  release the Shift key.



                            CELL REFERENCE

                  A cell reference is a cell address that can be used in a formula to denote a specific cell. A formula
                  may contain reference to other cells. In such a case, the result of a formula depends on the values

                  in the referenced cells. Cell references are especially helpful when you create complex formulas.
                  There are three types of cell references used in Excel: Relative, Absolute and Mixed.



                   22   Premium Edition-VI
   19   20   21   22   23   24   25   26   27   28   29