Solved

The Complete Formula That Corresponds to the Flowchart in the Accompanying

Question 12

Multiple Choice

The complete formula that corresponds to the flowchart in the accompanying figure is _____. A) =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500) ) B) =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500) ) C) =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500) ) D) =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500) )
The complete formula that corresponds to the flowchart in the accompanying figure is _____.


A) =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500) )
B) =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500) )
C) =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500) )
D) =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500) )

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q7: Identify the letter of the choice that

Q10: The _ error value means that a

Q14: Identify the letter of the choice that

Q15: A(n)_ IF function is when one IF

Q18: If you are not sure of a

Q54: The Conditional Formatting button provides access to

Q70: You can use _ to reference cells

Q75: To change the background fill color of

Q83: Discuss strategies for checking formulas for matching

Q91: A(n)_ specifies the type of condition the