Question

Arthur needs to copy the formula in cell C13 to cell D13. He needs cell D13 to have the same formula but referenced with a new location. Which type of cell reference should be used?

Answer 1

Arthur needs "relative cell reference" to copy cell C13 to D13 including the formula from cell C13.

In Microsoft Office Excel, there are two types of cell references: the relative cell reference and the absolute cell reference. Relative cell reference is by default. This reference is convenient because whenever you need to copy a cell across other cell it also repeat the same calculations.