You Have Been Using a Variety of Nested IF Functions

question 27

Multiple Choice

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.
-Which of the following is an effective alternative for the use of extensive nested IF functions?

• A)compare table
• B)function table
• C)lookup table
• D)case table

---

Definitions:

Inflation Rate

The rate at which the general level of prices for goods and services is rising, and, subsequently, the purchasing power of currency is falling.

Pure Rate

The interest rate exclusive of all other elements such as risk premium, inflation, or other costs often considered the real rate of interest with no adjustments.

Default Risk Premium

The additional yield that a borrower must offer to compensate lenders for the risk that the borrower may fail to make required payments.

Corporate Bond

A type of debt security issued by corporations to finance their operations, projects, or expansion plans.