Page 19 - iPro_trackGPT_V5_Class8
P. 19

By Using the Shift Key

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




                                                                                                    2  Press and
                       1  Click on
                                                                                                   hold the Shift
                      the cell from
                                                                                                   key and click
                      which you
                                                                                                   on the cell up
                      want to start
                                                                                                   to which you
                      the range.
                                                                                                   want to make
                                                                                                   the selection.
                 The cell range is selected once the Shift key is released.
                 Naming a Cell Range

                 Excel allow you to assign a name to a cell or a range of cells. This name can then be used in
                 formulas instead of cell addresses, making formulas easier to read and manage.
                 The steps to naming a cell range are as follows:


                   2  Click on the Formulas tab.            3  Click on the Define Name command.




                                                                       4  Type the name
                                                                      in the Name box.





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

                                                                                           5  Click on the OK button.





                                                                                The moon highlights different
                                                                               aspects at different times, much
                                                                                like filtering focuses on specific
                                                                                         data subsets.




                 Now, we can use this name in place of the cell address in formulas.
                    DIFFERENT WAYS TO ENTER FORMULAS

                 There are two main ways to add a formula to a worksheet:

                    Enter the Formula Directly into the Cell: You can enter the formula directly into a cell by
                    typing an equal sign (=) and then enter the formula you want to use.



                                                                             Spreadsheet—Functions and Charts    17
   14   15   16   17   18   19   20   21   22   23   24