Which of the Following Functions Is Used to Find the Largest

question 28

Multiple Choice

Which of the following functions is used to find the largest value in a range of cells using Microsoft Excel?

• A)MAX(range)
• B)MIN(range)
• C)SUM(range)
• D)AVERAGE(range)

---

Definitions:

Underlying Asset

An asset (such as a stock, bond, commodity, or currency) upon which a derivative instrument, such as an option, is based.

Interest Rate Futures

Financial futures contracts that obligate the buyer to purchase an asset (like Treasury bills) with a fixed interest rate at a future date.

Federal Funds

Short-term funds transferred between financial institutions, typically overnight, at an interest rate set by the Federal Reserve in the United States.

Repurchase Agreements

Short-term borrowing for dealers in government securities, where the dealer sells the government securities to investors, usually on an overnight basis, with an agreement to buy them back.