Page 25 - Computer Genius Class 06
P. 25

Understanding Cell Range

                   group o  selected cells is called a range. The selected cells should  e in continuation to  orm a
                 range.  hen a range is selected in a  or sheet  a rectangular shape is  ormed.  e can use a cell
                 range to per orm a calculation on multiple cells. The address o  a range is created  y using the
                 starting and ending cell addresses separated  y a colon     sign. For e ample  i   e ha e selected the
                 cells  rom  2 to     then the address o  the range  ill  e  2   .

                 Selecting a Range in a Worksheet

                  e can select a range  y using the mouse and  y using the  hi t  ey.

                 By using the Mouse

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

                                             1  Click on the first cell from which
                                            you  ant to start the range.















                                                               2  Drag and  drop the  left  mouse
                                                               utton to select the desired range.


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


                                                1  Click on the first cell from which
                                               you  ant to start the range.


















                                              2  Press and hold the Shift key and click on the last
                                              cell up to  hich you  ant to ma e the selection.

                  hen the  hi t  ey is released. The range gets selected.




                                                                              Formulas and Functions in Excel  23
   20   21   22   23   24   25   26   27   28   29   30