Exel - Cell References and Copying to Word

Relative Reference - This means that when you reference a cell in a formula and you use the formula for different cells, the cells in the formula will move across and down depending on where the cell is that you chose to use.
 

Absolute Reference - This is used in a formula to set a cell so when the formula is used in different cells, the cell you have set will stay the same.  You do this by adding '$' before the letter or number reference for the cell, depending on what you want to stay the same.  eg  =B2+$A$8     A8 will stay in the formula even when you change the cell.   





Copying to Word - If you copy and paste information from excel to word you will have many different paste options.  One of them is 'linking'.  This means that if you change something on the original excel document, the information will also change on the word document.