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:

AGI

Adjusted Gross Income, which is gross income minus adjustments, serving as the basis for calculating taxable income.

Annuity Contract

A financial product sold by an insurance company that provides guaranteed income over a period of time for a flat or periodic payment.

After-tax Dollars

Money that an individual has left over after all income taxes have been deducted, which can then be invested or spent.

Tax-free

Financial gains or receipts that are not subject to tax by authorities, often due to specific exemptions or regulations.