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:

Ethical Dilemma

A situation in which a person is required to choose between two conflicting moral principles, making it difficult to decide what is right.

Quandary Ethics

Quandary ethics deals with situations where moral obligations conflict or where it's difficult to determine the right course of action, leading to ethical dilemmas or quandaries.

Character Ethics

A branch of ethics focused on virtues and moral character as the foundation of ethical behavior, rather than rules or consequences.

Happiness Concern

The issue or focus on understanding what factors contribute to human happiness and well-being.