Examlex

Solved

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%? 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:

Ethical Decision Making Models

Structured approaches to resolving moral dilemmas, often incorporating steps to identify and weigh the consequences of different actions based on ethical principles.

Confidentiality

Confidentiality involves the obligation to protect personal or sensitive information from unauthorized disclosure.

Supervisor

An individual in a position of authority responsible for overseeing the performance of employees and managing their work environment.

Lawyer

A professional who is qualified to offer advice about the law or represent someone in legal matters.

Related Questions