Page 48 - modular4.0
P. 48

Chapter Profile
                  When you copy the formula to the next cell, address of the cell D3 will remain same as shown.









                  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 of cell A2 in Sheet2 into cell A1 in Sheet1, do this:

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












                                                   2  Click the Sheet2 tab.


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

                                 Tech Funda



                      Pressing F4 key repeatedly over a reference (cell) will allow you to switch between making the
                      column, the row, or nothing ‘Absolute’.



                  Other Workbook References

                  You can refer to cells of a worksheet in other workbooks in the same way you refer to cells in other
                  worksheets within the same workbook. These references are called external references.

                  For example, to enter a reference to Book2 in Book1, do as follows:
                  Ensure you have two separate workbooks named Book1 and Book2. In Sheet1 of Book1, select cell
                  A1. Type an equal sign (=) in cell A1. Use the Alt+Tab keys on your keyboard to switch to Book2.




                46   Modular (Ver. 4.0)-VII
   43   44   45   46   47   48   49   50   51   52   53