Page 22 - Trackpad_ipro 4.1_Class8
P. 22

Tech


                      Funda

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


                  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 a ‘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.
                  To reference a cell in another worksheet, follow these steps:
                  Step 1  Select the cell where you want to enter the reference, such as A1 in Sheet1.
                  Step 2  Type an equal sign (=).

                  Step 3  Click on the tab for the other worksheet (e.g., Sheet2).
                  Step 4  Click on the cell you want to reference (e.g., A2 in Sheet2).
                  Step 5  Press the Enter key. You will return to Sheet1.
                  Step 6  Click on cell A1, and you will see the formula in the formula bar =Sheet2!A2.

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

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

                  To enter a reference to Book2 in Book1, follow these steps:
                  Step 1  Create two workbooks named Book1 and Book2.
                  Step 2  In Book1, select cell A1 in Sheet1 and type an equal (=) sign.
                  Step 3  Switch to Book2 by pressing Alt+Tab. Click to select cell A2 in Sheet1 of Book2.

                  Step 4  Press the Enter key.
                  After pressing Enter, the formula in Book1 cell A1 should appear as:
                  = [Book2] Sheet1! $A$2
                  This reference has 3 parts:
                  1.  Workbook: Book2 enclosed in square brackets

                  2.  Worksheet: Sheet1 followed by an exclamation mark (!)
                  3.  Cell: Absolute reference A2



                    20     iPro (Ver. 4.1)-VIII
   17   18   19   20   21   22   23   24   25   26   27