If You Use an INDEX Formula That Refers to Ranges

question 80

Multiple Choice

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

• A) #VALUE
• B) #REF!
• C) #ERROR
• D) none of the above

---

Definitions:

Gain or Loss

The financial result that occurs when the selling price of an asset differs from its purchase price, either as a profit or a deficit.

Share Issue

A process by which a company distributes new shares to shareholders, either as part of a public offering or a private placement.

Acquisition Differential

The difference between the cost of an acquisition and the fair value of the net identifiable assets acquired.

Ownership Interest

Refers to the percentage or portion of a company that is owned by a shareholder, indicating a claim on assets and possibly a right to the income of the company.