Question

If the position of the cell containing a formula changes, the ______________ remains the same.

mixed references
absolute references
relative references
range

Answer 1

Absolute reference is the correct answer to the given question .

Step-by-step 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 .