The accompanying data for the S&P 500 provides open, high, low, and close values for the S&P index over a period of time. Complete parts a through c below. Click the icon to view the S&P Index. a. Enter any day from June to July 2013 within the range of the data in cell G2. Use a MATCH function in cell G3 to find the row in the database that corresponds to this day. Day 19 (representing July 19, 2013) has been added to cell G2. What MATCH function should be used in cell G3 to find the row in the database that corresponds to this day? A G 1 S&P 500 Data 123 Day (June to July 2013) 25 450... 26 27 B C D E F Day 19 Database Open High Low Close 1577.521593.79 1577.09 1588.03 1592.27 1606.83 1592.27 1603.26 1606.44 1620.07 1606.44 1613.20 row Using this MATCH function in cell G3, day 19 returns the row b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a. What INDEX function should be used in cell G4 to find the closing value on this day used for the answer in part a? b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a. What INDEX function should be used in cell G4 to find the closing value on this day used for the answer in part a? A 1 S&P 500 Data 2 3 Day B C D E F G Day 19 Database 25 (June to July 2013) Open High Low Close 1577.521593.79 1577.09 1588.03 row 5 26 1592.27 1606.83 1592.27 1603.26 6 27 1606.441620.07 1606.44 1613.20 Using this INDEX function in cell G4, the closing value on the day in part a is (Type an integer or a decimal. Do not round.) C. Combine the MATEUS. LINDERS c. Combine the MATCH and INDEX functions in parts a and b into one function that displays the closing value in cell G5 What combination of the MATCH and INDEX functions displays the closing value in cell G5? A 1 S&P 500 Data 2 3 Day 4 5 B C D E F Day 19 Database (June to July 2013) Open High Low Close 25 26 27 1577.521593.79 1577.09 1588.03 1592.27 1606.83 1592.27 1603.26 1606.441620.07 1606.44 1613.20 row G