Question 11 (1 point) Yogli Mogli is a self-serving frozen yogurt chain store. Its midtown Atlanta location offers several flavors including Vanilla, Chocolate, Mango, Strawberry and Peach. Its store manager Jason Dickerson, recorded the sales of the last seven days, as well as the day of the week and top selling flavor in the following Excel worksheet. C Entry IDDay of the Week Tuesday Wednesday Thursday Friday Saturday Top Selling Flavor Vanilla Chocolate Strawberry Vanilila Strawberry Strawberry Sales $12,220 $15,300 $16430 $24,400 $35,500 $33,650 $11,700 3 5 6 Sunday Monday Chocolate 7 Jason wants to use the data to decide which flavor he should stock extra for a given day of the week. He plans to use Excel function VLOOKUP (value, table, col index, range lookup) to find the sales for Sunday What should be the value. table, col index, and range lookup, respectively? Sunday, A2:D8, 3, False Sunday, A2:D8, 3, True Sunday, B2:D8, 2, True Sunday, B2:D8, 2, False Question 8 (1 point) If the value in A5 is 60, what would be following formula return 'IF(A5-60, "Equal", "Not Equal")? 1) Not Equal 2) Equal 3) 60 4) None of the above Saved Question 9 (1 point) Which of the following statements about VLOOKUP is NOT correct? The output column must be on the right side of the 1st column in the lookup table Lookup value can be compared to any column of the lookup table It can help us find either exact or approximate match from lookup table Any column in the lookup table except for the 1st column can be used as output. Saved Question 10 (1 point) If cell E2 contains this formula: -VLOOKUP (B2. M4:08, 3), then upon evaluation what will E2 return? 1) a value from 04:08 2) a value from N4:N8 3) a e from M4:M8 4) B2