What Is the Significance of an Absolute Cell Reference in Excel

question 42

Multiple Choice

What is the significance of an absolute cell reference in Excel?

• A) The cell reference will not change if the formula containing the reference is copied to another location
• B) The cell will always contain the absolute value of any number entered into it
• C) The cell reference changes if the formula containing the reference is copied to another location
• D) It is the only formula used to refer to a cell on another spreadsheet

---

Definitions:

Cash Dividend

A distribution of profits by a corporation to its shareholders in the form of cash.

Cash

Money in the form of coins or banknotes, especially that held by a person or business.

Stock Investments

Financial assets referring to shares purchased in other companies intended for income generation or capital gains.

Cost Method

An investment accounting approach where the investment is recorded at cost and adjusted only for dividends received, not market value changes.