Page 43 - Plus_V2.2_C6_Flipbook
P. 43

For example, to enter a reference to cell B8 in Sheet1 into cell B8 in Sheet2, do this:
                 Step 1:  Select cell B8 in Sheet2, and type an equal (=) sign.

                 Step 2:  Click the Sheet1 tab.
                 Step 3:  Click cell B8, and then press Enter key. When you press Enter key, Sheet2 is now active.
                 Step 4:  Select cell B8, and you will see that it contains the formula =Sheet1!B8.

                 The exclamation point separates the worksheet portion of the reference from the cell portion.






















                                                     References to Other Worksheets



                                                             Tech Hint
                     To switch between making the column, the row, or nothing ‘Absolute’: press the F4 key
                     repeatedly over a reference (cell).





                  Let’s PraCtiCe

                   If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
                   the following formulas:

                   1.  (A1 - A2) * A3             _________________________________________
                   2.  A3 + (A1 * A2)             _________________________________________

                   3.  A1 * (A2 + A3) – 10        _________________________________________





                        FUNCTIONS


                 Functions are predefined formulas in Excel to perform both simple and complex calculations.
                 They accept arguments and return values. Arguments are input to the functions. These
                 arguments can be numbers or text. The values should be given in between opening and closing ( )
                 parenthesis.



                                                                               Formulas and Functions in Excel 2016  41
   38   39   40   41   42   43   44   45   46   47   48