Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 50 - 2620_Birla Open Mind C-6
P. 50

    Mixed References

                  A mixed reference is a reference that refers to a specific row or column. It is basically a combination
                  of relative and absolute references. In some situations, you may need to make the cell reference as
                  ‘Mixed’ reference, so that you can lock either a column or a row by preceding it with a Dollar ($) symbol.

                  For example, $A1 or A$1.

                       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        Select cell A1 in Sheet 1, and you will see
                        and type an equal (=) sign.  1  then press Enter key.   3     that it contains the formula = Sheet2! A2.

                                                                      2
                                                Click the Sheet2 tab.

                  The exclamation point separates the worksheet name of the reference from the cell address.

                                                                      Hintbot

                           When writing formulas, any portion of the formula that denotes a cell or range of cells can be
                           made absolute by hitting the F4 key while your cursor is on that cell reference.

                             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 in the cell A4:
                     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. The arguments can be
                  numbers or text. The values should be given in between opening and closing ( ) parenthesis.

                      48  Premium Edition-VI

| 45 46 47 48 49 50 51 52 53 54 55 |