relative and absolute cell referencing.

Absolute cell referencing

absolute cell referencing is mainly used when you're on excel. Absolute cell referencing is when you use a cell in a formula, and if you copy, move or duplicate the formula then these cells will never change. you make a cell in a formula into absolute referencing by adding dollar signs. if you put a dollar sign in front of the letter then the cell reference will make sure that it stays in that column. if you put a dollar sign in front of the number then it will keep that row. by putting dollar signs in front of both the letter and the number it means that we reference that one cell, and only that cell.

we can use absolute cell referencing when we want to use a formula and we want it to always refer back to that cell. a good use of this would be if we had to see whether a set of number is equal to a specified number. say we have a set of 10 random numbers and we want it to say 'match' if the random number and the specified number are the same. for this we could use one formula for the first number and absolute cell reference the specified number. we can then use this formula for each of the numbers and they should all accordingly change but not the absolute referenced cell.

Relative cell referencing

Relative cell referencing is the opposite to absolute cell referencing. if you have a formula in a cell and you try to move, change or duplicate the formula then all the cells will change accordingly in the cell. if we want to do the formula =B2+C2 and we put this formula in D2, then it would simply show us the right outcome. if we then copied this formula and put it into cell D3 then we would find that the formula will change to =B3+C3. this can come in handy when working with a mass of cells.