Answer:
Absolute reference is the correct answer to the given question .
Explanation:
If the formula is copied from the another cell , the absolute reference is not modified. it remains the same as before. however If the formula is copied from the another cell , the relative reference is modified.
In the formula cell of the absolute reference is represented by incorporating the dollar sign i.e :$" previously the row and column. For example ($B$2) however the relative reference is represented by B2 only.
- In the Relative reference a cell containing the formula changes then relative reference is modified that's why it is incorrect option
- Mixed references is the collection of both so its a incorrect option according to the question.
- Range is totally incorrect option according to the given question .
