As You Insert and Delete Rows and Columns, Excel Adjusts

question 48

Short Answer

As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.

---

Definitions:

Average Rate

Typically refers to the mean rate or typical value for a given measure over a set time period or dataset.

Returns

The gain or loss on an investment over a specified period, typically expressed as a percentage of the investment's initial cost.

Years

Units of time representing a period of approximately 365 days or 12 months, commonly used to measure durations and intervals in financial contexts.

Real Rate of Return

The annual percentage return realized on an investment, which is adjusted for changes in prices due to inflation or other external effects.