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 now wants to send any orders for more than 30 toys to Warehouse 2. She is looking for the position where the smallest value is greater than 30. She will send the orders starting from that position on to Warehouse 2. The correct formula would be ____.
Definitions:
Operating Leverage
An indicator of how increases in revenue lead to rises in operational profit, reflecting the company's balance of fixed to variable expenses.
Fixed Costs
Expenses that do not vary with production level or sales volume, such as rent, salaries, and insurance premiums.
Rent
Payment made by a tenant to a landlord for the use of a property.
Depreciation
The allocation of the cost of an asset over its useful life.
Q22: -5<br>A)=ROUND(25.449,0)<br>B)=ROUND(SUM(10.33,10.44),0)<br>C)=ROUND(25.33%,2)<br>D)=INT(-4.3)<br>E)=ROUND(103234,-2)<br>F)=ROUND(23.75%,2)<br>G)=ROUNDDOWN(9.99,0)<br>H)=EVEN(2.23)
Q33: The breaking point is the point at
Q34: What is one of the weaknesses of
Q52: In an INDEX function, the argument _
Q65: For an OR function to be TRUE,
Q76: _ charts are named for their resemblance
Q77: A(n) _ chart combines the features of
Q129: When creating a range for use with
Q136: In the formula Mark is discussing with
Q145: With the INDEX function, if you are