mework Question 12, 2.4.25 HW Score: 79.09%, 79.09 of 100 points S Part 4 of 5 Points: 4.8 of 8 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 July to August 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 1 (representing August 1, 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 B C D E F G 1 S&P 500 Data 2 Day 3 Day Database (July to August 2013) Open High Low Close row =MATCH(G2,A4:A23,0) 22 1694.41 1697.61 1690.67 1695.53 5 23 1696.63 1698.78 1691.13 1692.39 6 24 1696.06 1698.38 1682.57 1685.94 Using this MATCH function in cell G3, day 1 returns the row 9. 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 B C D E F G S&P 500 Data 2 Day 3 Day Database (July to August 2013) Open High Low Close row 4 22 1694.41 1697.61 1690.67 1695.53 =INDEX(A4:E23,G3,5) 5 23 1696.63 1698.78 1691.13 1692.39 24 1696.06 1698.38 1682.57 1685.94 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.)S&P Index A B 1 S&P 500 Data 2 3 Day Open High Low Close (July to August 2013) 4 22 1694.41 1697.61 1690.67 1695.53 5 23 1696.63 1698.78 1691.13 1692.39 6 24 1696.06 1698.38 1682.57 1685.94 25 1685.21 1690.94 1680.07 1690.25 8 26 1687.31 1691.85 1676.03 1691.65 29 1690.32 1690.92 1681.86 1685.33 10 30 1687.92 1693.19 1682.42 1685.96 11 31 1687.76 1698.43 1684.94 1685.73 12 1 1689.42 1707.85 1689.42 1706.87 13 2 1706.10 1709.67 1700.68 1709.67 14 1708.01 1709.24 1703.55 1707.14 15 6 1705.79 1705.79 1693.29 1697.37 16 7 1695.30 1695.30 1684.91 1690.91 17 CO 1693.35 1700.18 1688.38 1697.48 18 9 1696.10 1699.42 1686.02 1691.42 19 12 1688.37 1691.49 1683.35 1689.47 20 13 1690.65 1696.81 1682.62 1694.16 21 14 1693.88 1695.52 1684.83 1685.39 22 15 1679.61 1679.61 1658.59 1661.32 23 16 1661.22 1663.60 1652.61 1655.83