replicating formulas

Question 1

Term: Relative Addressing

Answer 1

📘 Meaning: Cell references change when copied to another location.
🧮 Example:
Original: =A1+B1
Copied to next row: =A2+B2

Question 2

Term: Absolute Addressing

Answer 2

📘 Meaning: Cell references stay fixed when copied, using dollar signs $.
🧮 Example:
=$A$1 + $B$1 → Always refers to A1 and B1, no matter where it’s copied.

Question 3

Term: Mixed Addressing

Answer 3

📘 Meaning: Only one part (row or column) stays fixed.
🧮 Example:
=$A1 → Column A is fixed, row changes.
=A$1 → Row 1 is fixed, column changes.

Question 4

Term: Naming of Ranges

Answer 4

📘 Meaning: A range of cells is given a custom name for easier use in formulas.
🧮 Example:
Define range A1:A5 as Sales, then use =SUM(Sales).

Question 5

Operation: Copying a Formula

Answer 5

📘 Effect:

With relative references, cell addresses change based on the new position.

With absolute references, cell addresses stay the same.

Named ranges stay unchanged.

Question 6

Operation: Moving a Formula

Answer 6

📘 Effect:

Relative references adjust based on the new location.

Absolute and named references remain unchanged.

The formula itself is moved, not duplicated.

Question 7

Operation: Deleting a Cell in a Formula Range

Answer 7

Effect:

If a cell used in a formula is deleted, you may get an error (#REF!).

The formula breaks if its referenced cell no longer exists.