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:

Contest

A brand-sponsored competition that requires some form of skill or effort.

Sweepstakes

A form of sales promotion that offers prizes based on a chance drawing of entrants’ names.

Persuasive Advertising

A type of advertising aimed at encouraging potential customers to buy a product or service by appealing to their emotions, desires, or reason.

Target Audience

A specific group of consumers identified as the recipients of a particular marketing message or campaign.