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:

Yield Strength

The highest stress a material can withstand without permanent deformation expressed in psi. In steels, yield strength is typically about 10 percent less than tensile strength.

Tempered Steel Alloy

steel that has been heat-treated to increase its strength and toughness, often used in applications requiring durability and resistance to wear.

Class 8 Truck

A classification for heavy trucks with a Gross Vehicle Weight Rating (GVWR) exceeding 33,000 pounds.

Frame Rails

The long, structural members of a vehicle frame that provide support and shape to the vehicle's body and chassis.