Which Function Calculates the Reduction in C2 to Be Filled

question 16

Multiple Choice

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%?

• A)=IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2))
• B)=IF(A2="Silver",B2*0.1,B2*0.2)
• C)=IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2))
• D)==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2)))

---

Definitions:

Hurtful Temperatures

Extreme temperatures that can cause physical harm to the body, including hypothermia from cold and burns from excessive heat.

Gate-Control Theory

A theory that suggests pain is not merely a direct result of activation of pain fiber receptors, but is also subject to modulation by interneurons in the spinal cord that can 'gate' pain signals.

Large-Fiber Activity

Large-Fiber Activity refers to the actions or responses of large-diameter nerve fibers, which are typically involved in the transmission of touch and proprioceptive information.

Spinal Cord

The major column of nerve tissue that is connected to the brain and lies within the vertebral canal and from which the spinal nerves emerge.