[solved]-Vlookup Used Compute Cost B9 2 Lookup Table 3 Order Qty Cost Un 8 Order Qty 9 Cost 10 Cost Q39004955

VLOOKUP will be used to compute the cost in B9. 2 Lookup table 3 Order Qty Cost No un A 8 Order qty 9 Cost 10 The cost is determined by the following rule: • The cost is $20 if the order quantity is greater than 2999. The cost is $25 if the order quantity is between 2000 and 2999. The cost is $30 if the order quantity is less than 2000. Question 9 (0.5 points) B6 = 20 25 30 Question 10 (1 point) B9 = VLOOKUP(A4:B6, 2) VLOOKUP(B8, A4:B6, 2) =VLOOKUP(A4, $A$4:$B$6, 2) VLOOKUP(B8, A4:B6, 1) Answer the questions based on the following model: C D Price Revenue 1 Profit 2 Revenue 3 Price 4 Tickets sold 5 Total cost 6 TVC 7 Unit computer cost / day 8 # of days in the seminar 9 TFC B 1200 12000 600 20 10800 1200 60 100 150 200 250 300 350 400 450 500 550 600 9600 11 13 Question 11 (1 point) Data-Table will be used to create a table of revenues of different prices in columns E:F. What is the correct formula in F2? O=A2 O=A1 Question 12 (1 point) What range should be selected before clicking the following menu? What-If Forecast Group Ung al Analysis. Sheet Scenario Manager… Goal Seek… Data Table… E3:F13 E1:F13 E2:F13 F3:F13 Show transcribed image text VLOOKUP will be used to compute the cost in B9. 2 Lookup table 3 Order Qty Cost No un A 8 Order qty 9 Cost 10 The cost is determined by the following rule: • The cost is $20 if the order quantity is greater than 2999. The cost is $25 if the order quantity is between 2000 and 2999. The cost is $30 if the order quantity is less than 2000.
Question 9 (0.5 points) B6 = 20 25 30
Question 10 (1 point) B9 = VLOOKUP(A4:B6, 2) VLOOKUP(B8, A4:B6, 2) =VLOOKUP(A4, $A$4:$B$6, 2) VLOOKUP(B8, A4:B6, 1)
Answer the questions based on the following model: C D Price Revenue 1 Profit 2 Revenue 3 Price 4 Tickets sold 5 Total cost 6 TVC 7 Unit computer cost / day 8 # of days in the seminar 9 TFC B 1200 12000 600 20 10800 1200 60 100 150 200 250 300 350 400 450 500 550 600 9600 11 13
Question 11 (1 point) Data-Table will be used to create a table of revenues of different prices in columns E:F. What is the correct formula in F2? O=A2 O=A1
Question 12 (1 point) What range should be selected before clicking the following menu? What-If Forecast Group Ung al Analysis. Sheet Scenario Manager… Goal Seek… Data Table… E3:F13 E1:F13 E2:F13 F3:F13