Violet is learning how to use the MATCH function and is testing several different formulas. The chart above shows orders for small robot toys from five different customers. The amount "0" in column A is for a customer who changed his mind. Please answer the questions below using the data in the figure above.
-Violet wants to send any orders for 30 toys or fewer to Warehouse 1 to ship out. To do this, she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.
Definitions:
Profit Margin
The percentage of revenue that turns into profit after all expenses have been deducted.
Mason
A skilled tradesperson who works with brick, stone, and other durable materials to build or repair structures.
Responsibility Accounting Reports
Financial reports that measure the performance of organizational units or departments, emphasizing the accountability of managers for controllable costs.
Profit Centers
Divisions or segments within a company that are directly responsible for generating profits, evaluated based on their performance.
Q5: The function =C2="Hello" uses relational operators to
Q21: A list of values can contain _.<br>A)
Q59: NOT(H2=2) returns the value FALSE assuming that
Q75: _ identify the categories plotted on the
Q118: With _, you can specify your own
Q118: The _ function calculates the number of
Q120: _ returns the cumulative principal paid on
Q125: The NOT function evaluates only one logical
Q142: Robert wants to send a special gift
Q142: In a worksheet, you can add up