Multiple Choice
Mark is in charge of determining the unit pricing for each order for robot toys. Please refer to the chart above as you answer the questions below.
-Mark writes a formula to look up the unit pricing for each order. He starts by writing one for Order #1 and then plans to copy it from E12 to E13:E16. The correct formula would be ____.
A) =VLOOKUP(D12,A$7:B$8,3,TRUE)
B) =VLOOKUP(D12,A$7:B$8,2,TRUE)
C) =VLOOKUP(D12,A$7:B$8,0,TRUE)
D) =VLOOKUP(D12,A$7:B$8,1,TRUE)
Correct Answer:

Verified
Correct Answer:
Verified
Q19: With the INDEX function, you can use
Q20: Identify the letter of the choice that
Q21: MATCHING<br>Identify the letter of the choice that
Q22: In a LOOKUP function, the argument _
Q23: In a one-dimensional table, Excel searches one
Q25: The LOOKUP function uses a _ lookup
Q26: A data list that categorizes values you
Q27: The syntax of the CHOOSE function is
Q28: When solving an HLOOKUP formula, Excel looks
Q29: The first row (key values) of the