To Display Data or Formula Results from One Worksheet in Another

question 11

Short Answer

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

---

Definitions:

Present Value

The value today of a sum of money to be received in the future, after accounting for a certain return rate.

Compound Interest

Compound interest is the addition of interest to the principal sum of a loan or deposit, or in other words, interest on interest. It's the result of reinvesting interest rather than paying it out, so that interest in the next period is then earned on the principal sum plus previously accumulated interest.

Earnings Rate

The return on an investment for a specific period, typically expressed as a percentage of the investment's initial cost.

Internal Rate Of Return

A financial metric used to evaluate the profitability of potential investments, calculated as the discount rate that makes the net present value of all cash flows from a project equal to zero.