MINDTAP el: Graded Tutorial #2 (Ch. 2) $ 58 hundred Question 5. The MATCH function can use a cell reference for the lookup value. Use the dropdown box in cell F13 to find the sales data fo NewspaperAd which will appear in cell F11. Enter your answers in hundreds of dollars. GoogleAd: $ hundred NewspaperAd: $ hundred The INDEX/MATCH functions can also be used with statistical calculations. For example the function =INDEX($A$1:$A$4, MATCH(MIN($B$1:$B$4),$B$1:$8$4,0)) will 1) find the minimum value for $B$1:$8$4 which is 32478, which is "East." relative position of that value using MATCH which is 3 and then 3) look in A1:A4 to see which value corresponds to that relativ B North 50247 South 47125 East 32478 4 West 75763 Question 6. Choose the correct data requested in E15 by using a combination of INDEX/MATCH/MIN functions in cell F15. Check My Work Reset Problem Back Autosaved at 8:46 PM O W 144 no prt sc delete home % 5 8 C O backspace num 6 lock