ework Question 12, 2.4.25 HW Score: 74.17%, 74.17 of 100 points 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. (July to August 2013) Open High Low Close row -IVIATOR(34,A4.AZ5,V) 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 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? 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 6 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 C 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 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 5 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 8 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