The HLOOKUP Function

question 42

Multiple Choice

The HLOOKUP function

• A) is the periodic interest rate, such as a monthly interest rate.
• B) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
• C) looks up a value in a lookup table where the first column contains the values to compare with the lookup value.
• D) looks up a value in a lookup table where the first row contains the values to compare with the lookup value.

---

Definitions:

Price Elasticity

A measure of how much the quantity demanded of a good responds to a change in the price of that good, expressed as a percentage change.

Excise Tax

A tax levied on specific goods or commodities sold within a country, such as alcohol and cigarettes.

Price Elasticity

A parameter for gauging the response of demand to price variations of a product.