Copying data - Reference calculation

Page visited 11474 times

 
1. As in the non-reference calculation section, the target-cell will contain the formula in the source-cell.
Excel-Exercise-Tutorial-1
 
 
 
2. Nevertheless, the reference to the source-cell will change as soon as it is copied.
Excel-Exercise-Tutorial-2
 
 
3. For example, cell B5 is the sum of cell B3 and B4. When you copy cell B5 to C5, you will note, in the formula bar, that the content of cell C5 is :
Excel-Exercise-Tutorial-3
Formule de la cellule
=C3+C4
 
 
 
4. In the Complement/References section you will learn how to block a reference of a cell when copying.
Excel-Exercise-Tutorial-4
 
 
 
5. Copy cell B6 to C6.
Excel-Exercise-Tutorial-5
 
 
 
6. If the variable expenses are raised to 450 euros. You will notice that the content of cell C5 will change immediately but the formula is the same.
Excel-Exercise-Tutorial-6