Multiple Choice
The complete formula that corresponds to the flowchart in the accompanying figure is ____.
A) =IF([Pay Grade]=2,2500,IF([Pay Grade]=1,5000,7500) )
B) =AND([Pay Grade]=2,2500,AND([Pay Grade]=1,5000,7500) )
C) =IF([Pay Grade]=1,2500,IF([Pay Grade]=2,5000,7500) )
D) =AND([Pay Grade]=1,2500,AND([Pay Grade]=2,5000,7500) )
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The _ function searches horizontally across a
Q11: The _ error value means that a
Q21: The _ error value means that for
Q25: When you want to reference an entire
Q28: The _ error value means that a
Q48: An error value begins with a number
Q81: The _ function is a logical function
Q88: MATCHING<br>Identify the letter of the choice that
Q126: The _ error value means that the
Q135: A(n)_ table is a table that organizes