Page 44 - Plus V4 with Adobe class 6
P. 44

REFERENCES TO OTHER WORKSHEETS


        You can refer to cells in other worksheets within the same workbook just as easily as you refer to cells in
        the same worksheet. For example, to enter a reference to cell A2 in Sheet2 into cell A1 in Sheet1, do this:

               Select  cell  A1  in  Sheet1,   Click on cell A2. and then      Select cell A1, and you will see that it
               and type an equal (=) sign.  1  press Enter key.          3      contains the formula = Sheet2! A2.











                                                            2
                                      Click the Sheet2 tab.

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


                                                         Hintbot


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



                   Interdisciplinary Learning

                   #Mathematics


           If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then calculate and write the output of the
           following formulas:
           a.  (A1 - A2) * A3
           b.  A3 + (A1 * A2)
           c.  A1 * (A2 + A3) – 10

                                                                                                   #Lab Activity


             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.

        Rules for Using Functions

            All Excel functions must begin with = sign.
            Function name must be a valid Excel name.
            Function must be followed by opening and closing parenthesis.

            Most of the functions must contain an argument within it.



            42  Plus (Ver. 4.0)-VI
   39   40   41   42   43   44   45   46   47   48   49