cell reference can be relative provide an exampleSolutionIn

cell reference can be relative, provide an example

Solution

In excel, cell reference refers to the address of a cell. There are 2 types of cell ranges: relative and absolute.

Cell ranges which are relative work as follows:

If we write a bunch of values in the cells A1:A10 (column A, rows 1 to 10) and then paste the formula in B1 \"=A1+1\" and hit the return key, we will get a value in the cell B1 which will be 1 more than the value in A1

Now if we copy this cell and paste it onto C1 then the formula that will be pasted in C1 will be relative formula \"=B1+1\"

This is because relative to B1, the action that was performed by the first function (written in B1) is \"add 1 to the cell left of me\". Hence, when the cell B1 is copied to cell C1, the same format of the formula applies, that is \"add 1 to the cell left of me\".

This is an example of relative cell referencing in Excel.