1 what is absolute referencing ?
2 what is relative ?
Answers
Answered by
0
- An absolute reference is designated in a formula by the addition of a dollar sign before the column and row. If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas. Relative references are used less frequently.
- A person who is connected with another or others by blood or marriage. Something having, or standing in, some relation or connection to something else. something dependent upon external conditions for its specific nature, size, etc. (opposed to absolute).
Answered by
1
Answer:
1) an absolute reference in an cell reference that intentionally won't change when an formula is copied.
2) if you copy if formula 3 rows down and one row left then the cell reference in the formula will shift 3 rows Down And One row left these are called relative cell reference.
Similar questions