The ________ Function Looks for a Value Within a Range

question 21

Multiple Choice

The ________ function looks for a value within a range and returns the position of that value within the range.

• A)INDEX
• B)MATCH
• C)INDIRECT
• D)VLOOKUP

---

Definitions:

Income Tax Overpayment

A situation where an individual or entity has paid more income tax to the government than was actually owed.

Canada Revenue Agency

The federal agency responsible for administering tax laws and various social and economic benefit and incentive programs delivered through the tax system for the Government of Canada.

Simple Interest

A method of calculating interest where the charge is based on the original principal amount and does not compound.

Principal Amount

The original sum of money lent in a loan or invested, excluding any interest or profits.