0 like 0 dislike
asked in Computer Science by (474k points)
What is relative referencing?

1 Answer

0 like 0 dislike
answered by (474k points)
A cell reference or relative cell reference describes how far away a cell or group of cells is from another cell in the same spreadsheet. When dealing with a spreadsheet formula, the relative cell reference is the default behavior of a formula. For example, to add cells A2 and B2 together you could use the formula "=SUM(A2+B2)" in cell C2, and if you were to copy that formula into cell C3, it would be relative to C3 and become "=SUM(A3+B3)."
Welcome to Free Homework Help, where you can ask questions and receive answers from other members of the community. Anybody can ask a question. Anybody can answer. The best answers are voted up and rise to the top. Join them; it only takes a minute:

10.2k questions

9.2k answers


3.2k users


Free Hit Counters