Which Function Should Be Used to Mask Zero Values in Templates

question 43

Multiple Choice

Which function should be used to mask zero values in templates?

• A)IF
• B)IFERROR
• C)VLOOKUP
• D)INDEX

---

Definitions:

Increase In Value

The appreciation or upward adjustment in the price or worth of an asset over time.

Maturity

The date on which the principal amount of a bond, loan, or other financial instrument becomes due and is to be paid back.

Zero-coupon Bond

A bond that does not make periodic interest payments during its life and is instead sold at a deep discount from its face value, with the full face value being paid at maturity.

Yield To Maturity

The cumulative income projected from a bond, provided it is retained till its expiration, factoring in both the interest disbursements and principal reimbursement.