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:

Egocentric

Having an inability to understand or assume any perspective other than one's own.

Preoperational Stage

A developmental stage ranging approximately from ages 2 to 7 during which children begin to engage in symbolic play and learn to manipulate symbols, but do not yet understand concrete logic.

Sociocultural Theory

The concept that cognitive development is heavily influenced by social interactions and cultural practices.