Page 21 - iprime_V2.2_class8
P. 21
To see how this works:
Step 1 Enter 10 in cell A1.
Step 2 Click on cell A2.
Step 3 Type =A1*2 in cell A2.
Step 4 Press the Enter key.
Specifying Formula
The value in cell A2 will be 20.
If you change the value in cell A1 from 10 to any other value,
the value in cell A2 will update accordingly.
Cell references are especially helpful when you create complex
formulas. Value with Updated Cell Referencing
There are three types of cell references used in Excel: relative, absolute, and mixed.
Relative References
In a relative reference, you refer to a cell that is a certain number of rows or columns away.
When a formula with a relative reference is copied from one cell to another, the cell references
adjust accordingly.
To use relative cell reference, follow these steps:
Step 1 Select the cell that contains the formula with references to other cells. In this case, we have
selected cell D3, with the =B3*C3 formula to calculate the amount to be paid for the product.
Step 2 Click on the Copy command from the Clipboard group under the Home tab.
Step 3 Select another cell where you want to copy the formula, then click on the Paste command
from the Clipboard group under the Home tab. Notice that in the Formula bar, the cell
references in the formula have changed according to the new location.
Using Relative Referencing
Spreadsheet—Functions and Charts 19

