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
   16   17   18   19   20   21   22   23   24   25   26