To Average the Range Beginning with B6 and Ending with B8

question 22

Multiple Choice

To average the range beginning with B6 and ending with B8, key

• A) =B6+B7+B8
• B) =B6..B8/3
• C) =average(B6:B8)
• D) average(B6..B8)

---

Definitions:

Interest Rate

The percentage at which interest is paid by a borrower for the use of money that they borrow from a lender.

Semi-Annually

Occurring or calculated over half a year; typically refers to interest computed twice a year.

Trust Fund

A legal entity established to hold assets on behalf of a person or group, often used for estate planning or to manage money for beneficiaries.

Present Value

A payment’s economically equivalent amount at a prior date, allowing for the time value of money.