Violet Is Learning How to Use the MATCH Function and Is

question 30

Multiple Choice

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.
-The Customer Service department tells Violet there is a 25% discount on orders of 500 toys or more. Violet knows there is only one order that large, for 1000 toys, so which of the following formulas does she write to find the position of this order?

• A) =MATCH(1000,25%,A1:E1,1)
• B) =MATCH(1000,A1:E1,0)
• C) =MATCH(1000,{1000,100,50,25,0},0)
• D) =MATCH(A1:E1,0,1000)

Understand the effects of inventory costing choices on gross profit.

Distinguish between the perpetual and periodic inventory systems and their impact on inventory valuation.

Understand how specific identification method is used and in what contexts it is most applicable.

Calculate gross profit under different inventory costing methods.

---

Definitions:

Identical Twin

A duo born from the same pregnancy, sharing the same genetic material because they originated from a single fertilized egg that split.

Fraternal Twin

A twin who is born as the result of two different eggs fertilized by two different sperm, leading to siblings who are genetically similar but not identical.

Genetic Factor

An element within genes that can influence traits or conditions, including the development of certain diseases or disorders.

Melatonin

A hormone produced by the pineal gland in the brain, crucial for regulating sleep patterns and circadian rhythms.