Mark Is in Charge of Determining the Unit Pricing for Each

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.
-One of Mark's co-workers asks what would happen if he changed the formula to one having a FALSE type. As an example for discussion, Mark writes: =VLOOKUP(Z10,H$1:I10,1,FALSE) . How does the FALSE type affect this formula?

A) The VLOOKUP function looks only for an exact match of the lookup_value.
B) The VLOOKUP function looks only for negative values in the lookup_value.
C) The VLOOKUP function looks for the first value that is greater than the lookup_value.
D) The VLOOKUP function looks for the first value that is less than the lookup_value.