If A7=21, Which of the Following =IF Statements Would Produce

question 11

Multiple Choice

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

• A)=IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• B)=IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• C)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• D)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")

---

Definitions:

Disposable Income

Financial endowment to households for the purpose of spending and saving after mandatory tax deductions.

Consumption

The use of goods and services by households. It represents the end-use of products and is a primary component of aggregate demand in an economy.

Disposable Income

The allocation of funds households have to spend and save, after income tax adjustments.

Wage Earning

The act of receiving regular compensation for labor or services, typically on an hourly, daily, or piecework basis.