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:

Wetlands

Areas of land where saturation with water is the dominant factor determining the nature of soil development and the types of plant and animal communities living in the soil and on its surface.

Clean Water Act

A United States federal law that regulates the discharge of pollutants into the nation's surface waters, including lakes, rivers, streams, and coastal areas.

Economic Benefits

Financial gains or advantages received as a result of specific actions, investments, or decisions.

Noncompliance

Failure or refusal to act in accordance with a law, regulation, or set of standards.