When Should You Use Relative Cell References

question 49

Multiple Choice

When should you use relative cell references?

• A) When you want to preserve the exact cell address in a formula.
• B) When you want to preserve the relationship to the formula location.
• C) When you want to insert a function.
• D) When you want to enter sequential values in a range of cells.

---

Definitions:

Conform

To align one's behavior or beliefs with the norms, rules, or standards of a group or society, often due to social pressure or the desire for acceptance.

Rational Choice Theory

An economic principle that assumes individuals always make prudent and logical decisions that provide them with the highest personal utility.

Exchange

In sociology, the act of giving one thing and receiving another between two parties, often analyzed within social, economic, or cultural contexts.

Altruism

The principle or practice of showing concern for the welfare of others, often at a cost to oneself, motivated by selfless concerns.