Ask Question
20 September, 09:27

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

+4
Answers (1)
  1. 20 September, 09:40
    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?
Find 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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers