An Excel User Should Use a Relative Cell Reference When

question 79

Multiple Choice

An Excel user should use a relative cell reference when it is important to ____.

• A) preserve the relationship to the formula location
• B) never change the formula
• C) preserve the exact cell address in a formula
• D) memorize the formula

---

Definitions:

Avoided

Deliberately staying away from or not doing something.

Listening

The active process of receiving, interpreting, and responding to verbal messages and non-verbal cues.

Resistant

The quality of being opposed to or defending against something, such as change, disease, or certain materials and substances.

Ideas

Mental concepts or thoughts that represent a person's understanding or imagination, which can be the basis for creativity, problem-solving, and innovation.