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:

CCA Class

A classification system used in Canadian tax law for the depreciation of property, plant, and equipment for tax purposes.

Pre-Tax Cost

The expense of an investment or project before accounting for taxes; it reflects the gross cost.

Net Advantage

An evaluation metric that identifies the benefits minus the costs of pursuing a specific action or investment.

Depreciation Tax Shield

A tax reduction achieved through deducting depreciation expenses, lowering taxable income.