Page 23 - Touchpad_Plus_V3.2_Class 7
P. 23
Dollar ($) symbol, i.e., you should use the formula as = $D$3 + $E$3 so that when you copy the
formula the original reference is retained. For example, if you copy or fill an absolute reference
in cell C2 to cell C3, it stays the same in both cells = $B$2.
Mixed 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. It is basically
a combination of relative and absolute references. For example, if you use a formula as
= $D$4 + E4, then you are making the value that is present in cell D4 as absolute and the
value in cell E4 as Relative.
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, and type an equal (=) sign.
Click the Sheet2 tab.
Click cell A2, and then press Enter key.
After you press Enter key, Sheet1 is now active. Select cell A1, and you will see that it contains
the formula =Sheet2.A2.
The period (.) 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 both absolute, or keeping them relative.
Other Workbook References
You can refer to cells in worksheets 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, follow these steps:
Step 1 Create two workbooks named Book1 and Book2 and save them.
Step 2 Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.
Step 3 Switch to Book2 by pressing Alt + Tab keys from the keyboard. Click to select cell A2.
Step 4 Press Enter keys.
After you press Enter key, your formula in Book1, Cell A1, should be
= ‘[fileaddress]’#$Sheet1.A2.
Formulas, Functions and Charts in Calc 21

