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?

Question

Computers and Technology

Guest

25 September, 22:19

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?

+4

Answers (1)

Know the Answer?

Rex · 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.