Mark Is in Charge of Determining the Unit Pricing for Each

question 104

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.

---

Definitions:

Demand Curve

The demand curve is a graphical representation showing the relationship between the price of a good and the quantity demanded by consumers, typically downward sloping.

Quantity Demanded

The total amount of a good or service that consumers are willing and able to purchase at a given price in a given time period.

Demand Curve

A graph showing the quantity of a good that consumers are willing and able to purchase at various prices.

Quantity Demanded

The total amount of a good or service that consumers are willing and able to purchase at a specific price.