Ask Question
28 December, 17:43

Which references are updated when you copy the formula = Sum (A$1:$B4) + 25?

select all that apply

column A

column B

row 1

row 4

value 25

relative cell references in a formula are automatically updated if the formula is copied to other cells.

absolute cell references in a formula cause the reference to be locked

the reference is not updated when the formula is copied

+2
Answers (1)
  1. 28 December, 18:13
    0
    Absolute references in excel are not updated when copied - and the relative are updated.

    Just from this statement we can know that the following two statements are correct:

    relative cell references in a formula are automatically updated if the formula is copied to other cells.

    absolute cell references in a formula cause the reference to be locked

    The phrase "the reference is not updated when the formula is copied" - this is false, as at least in some way the expressin is updated.

    When we look at the expression

    = Sum (A$1:$B4) + 25?, we see that row 1 and column B are locked

    and

    column A

    row 4

    are updated.

    As far as value 25 is concerned - absolute values are never updated.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Which references are updated when you copy the formula = Sum (A$1:$B4) + 25? select all that apply column A column B row 1 row 4 value 25 ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers