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?
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.
