Question: Case-Based Critical Thinking Questions Case 5-1 B D A E 25 50 100 1000 Violet is learning how to use the MATCH function and is

Case-Based Critical Thinking Questions Case 5-1 B D A E 25 50 100 1000 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 "O" 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? =MATCH(1000,25%,A1:E1,1) O =MATCH(1000, A1:E1,0) O =MATCH(1000,(1000,100,50,25,0),0) O =MATCH(A1:E1,0,1000)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Two Discussion Questions. A minimum of 200 words per question. Both questions are attached to the word document and each chapter to both questions are attached to the PDF. Any references/citations...

I'm in serious need of help in my accounting class (acc205) . I'm falling behind and I need help with this weeks assignment. for week three for the may-june month . can someone please help me ....

Listen to the following videos and then complete the assignments using the changed numbers on the guidance report. Place your answers on the guidance report. Open the Guidance Report and rework the...

Excelsior College PBH 321 CRITICAL EYE ON RESEARCH IN EPIDEMIOLOGY By the end of this activity, you will be able to illustrate the purposes, designs, weaknesses, and relevance of a randomized drug...

Can someone help me with this? I need it by tomorrow chapter 2 Issues in Accounting for Corporate Debt and Equity istockphoto Learning Objectives Be able to articulate the advantages and...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

1 For this task, imagine that you were asked to present to a class of master's level students who are enrolled in their first quantitative research methods course. Create a PowerPoint presentation...

REVISION QUESTIONS MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) Which of the following is a generic term that covers a broad range of...

If you were thinking about being an investor for an IPO, what sort of things would raise "red flags" or "concerns" when you reading the prospectus? When answering this question, refer when...

Congenital disease: The connexin-26 mutation is a genetic mutation that results in deafness. The probability that a person carries a gene with this mutation is 0.0151. Find the probability that...

how could you use your knowledge about time ( n ) , interest rate ( R ) , and initial investment amount ( PV ) to help you make future decisions about your personal 4 0 1 ( k ) or other retirement...

What is an example of constructive feedback? provide reference