An excel user should use a relative cell reference when it is important to ____. preserve the relationship to the formula locati

Question

sergey [27]

3 years ago

7

An excel user should use a relative cell reference when it is important to ____. preserve the relationship to the formula locati

on never change the formula preserve the exact cell address in a formula memorize the formula

Computers and Technology

1 answer:

adell [148] · Answer 1 · 2022-07-07T00:16:18+03:00

An excel user should use a relative cell reference when it is important to preserve the relationship to the formula location. When you create a formula that references other cells, excel does not normally "record" the exact cell address. Instead, it looks at the at the relationship that cell has to the other cell containing the formula.