​ When Are Relative, Absolute, and Mixed References Used in Excel

question 3

Essay

​ When are relative, absolute, and mixed references used in Excel? Briefly explain.

---

Definitions:

Future Earnings

Expected future profits of a company, often used to assess its valuation or the potential return on investment.

Market Value

The current quoted price at which an asset or service can be bought or sold in a public marketplace.

Gordon Model

The Gordon Model, also known as the dividend discount model, is a method to determine the intrinsic value of a stock based on a future series of dividends that grow at a constant rate.

Intrinsic Value

The actual, inherent worth of an asset, independent of its market value, often calculated by investors to assess a company's underlying value.