Page 25 - Digicode_AI_class_6
P. 25

Understanding Cell Range

            A group of selected cells is called a range. The selected cells should be in continuation to form a
            range. When a range is selected in a worksheet, a rectangular shape is formed. We can use a cell
            range to perform a calculation on multiple cells. The address of a range is created by using the
            starting and ending cell addresses separated by a colon (:) sign. For example, if we have selected the
            cells from B2 to E3, then the address of the range will be B2:E3.
            Selecting a Range in a Worksheet

            We can select a range by using the mouse and by using the Shift key.

            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 want to start the range.















                                                          2  Drag and  drop the  left  mouse
                                                         button 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 want to start the range.

















                                         2  Press and hold the Shift key and click on the last
                                         cell up to which you want to make the selection.

            When the Shift key is released. The range gets selected.




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