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:

Fee Splitting

The practice where a professional shares a portion of their fee with another professional in exchange for a referral, considered unethical in many fields.

Outright Quackery

The promotion and sale of fraudulent or ignorant medical practices and products.

Unnecessary Surgery

Surgical interventions that are not essential for the health or survival of the patient and could be avoided.

Techniques of Neutralization

A theory suggesting individuals rationalize or justify their deviant behaviors by denying responsibility, injury, or the victim, among other defenses.