Using the VLOOKUP Function,an Approximate Match Lookup Occurs When the Value

question 3

Multiple Choice

Using the VLOOKUP function,an approximate match lookup occurs when the value entered falls within a range of values in ____ of the lookup table.

• A) the first column
• B) any column
• C) the first row
• D) any row

---

Definitions:

State Tax Bracket

The division of income ranges that are used to determine the tax rate applicable to an individual's or entity's income within a particular state.

After-tax Return

The profit generated from an investment after all applicable taxes have been paid.

Tax Exemption

A monetary exemption which reduces taxable income, allowing certain income or transactions to be legally exempt from taxation.

Income Tax Rate

The percentage at which an individual or corporation is taxed on their income, which can vary based on income level and jurisdiction.