Defined Names with a Global Scope Can Be Created for Cells

question 20

Multiple Choice

Defined names with a global scope can be created for cells and ranges using the Name box in the Formula Bar, and using the ____ command in the Defined Names group on the FORMULAS tab.

• A) Create from Formula
• B) Create from Selection
• C) Create from Cell
• D) Create from Range

---

Definitions:

Annual Rates

Refers to the interest rate or growth rate over a one-year period, often used in financial contexts.

Strip Bond

A financial instrument resulting from the separation of the coupon payments and the principal of a regular bond, where each part is sold separately as a zero-coupon bond.

Market Yield

The return on investment for a security anticipated in the marketplace, reflecting its current price and income it generates.

Compounded Semi-Annually

Interest calculation method where the interest is added to the principal balance twice a year, leading to interest on interest.