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:
Anticipated Tax Credits
Tax credits that are expected to be received in the future, which can reduce the amount of taxes owed.
Income Tax Expense
The total amount of income tax that a company reports as an expense in its financial statements for a specific period.
Pretax Income
The total earnings of a company before taxes have been deducted, also known as earnings before tax (EBT).
LIFO Method
"Last In, First Out" method; an inventory strategy where the most recently produced items are sold first, leaving older inventory in stock.
Q4: The _ symbol(s) indicate(s) the location where
Q43: $10,000 compounded 1 time at 4% per
Q69: A lookup table in which the data
Q82: Scenario summary reports are created with _
Q99: #2<br>A)Data series<br>B)Chart title<br>C)Data table<br>D)X-axis labels<br>E)X-axis<br>F)Legend<br>G)Y-axis<br>H)Y-axis labels<br>I)Gridlines<br>J)Data point
Q107: With Solver, you can change the values
Q122: When using the CHOOSE function, if the
Q129: In a PMT function, the _ argument
Q143: To create a(n) scenario, you plan the
Q147: The SEARCH function is case sensitive.