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,TRU
B) =VLOOKUP(D12,A$7:B$8,2,TRU
C) =VLOOKUP(D12,A$7:B$8,0,TRU
D) =VLOOKUP(D12,A$7:B$8,1,TRU

Question

Quizplus · Accepted Answer

The correct formula for looking up the unit pricing for each order is VLOOKUP(D12, A$7:B$8, 2, TRUE). 
- D12 is the value we are looking up, which is the quantity of robot toys in each order. 
- A$7:B$8 is the table array where we will match the quantity. 
- 2 is the column index number for the unit price column in the table array. 
- TRUE ensures that we get an approximate match, which means it will return the next smallest quantity if the exact quantity is not found in the table. 
Copying this formula from E12 to E13:E16 will give us the correct unit pricing for each order.

Mark Is in Charge of Determining the Unit Pricing for Each