Case-Based Critical Thinking Questions Case 8-3 You Have Been Using

question 30

Multiple Choice

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​If you omit the range_lookup value from a LOOKUP function, which of the following is true?

• A)The function returns the #NAME? error value.
• B)Your function can only search the first column of the lookup table.
• C)It is considered an approximate match.
• D)It is considered an exact match.

---

Definitions:

Interest Rate Futures

Financial derivatives contracts that lock in the future delivery of an asset based on interest rates, commonly used for hedging and speculating on future interest rate movements.

Hedge

An investment made to reduce the risk of adverse price movements in an asset, often involving derivatives like options and futures.

Basis Risk

Risk attributable to uncertain movements in the spread between a futures price and a spot price.

Short Hedger

An investor who enters into futures contracts to protect against potential price declines in an asset they hold.