Page 25 - ThinkGPT_V2.1_C6_Flipbook
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 the mouse towards the cell up to
                                               which you want to make the selection.

                 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