A B C D E F 1 S&P 500 Data 2 3 Day (April to May 2013) 4 5 6 8 9 1 1 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Open High 17 1574.57 1574.57 18 1552.03 1554.38 19 1541.61 1555.89 22 1555.25 1565.55 23 1562.5 1579.58 24 1578.78 1583 25 1578.93 1592.64 26 1585.16 1585.78 29 1582.34 1596.65 30 1593.58 1597.57 1 1597.55 1597.55 2 1582.77 1598.6 3 1597.6 1618.46 6 1614.4 1619.77 7 1617.55 1626.03 8 1625.95 1632.78 9 1632.69 1635.01 10 1626.69 1633.7 13 1632.1 1636 14 1633.75 1651.1 Low Close 1543.69 1552.01 1536.03 1541.61 1539.4 1555.25 1548.19 1562.5 1562.5 1578.78 1575.8 1578.79 1578.93 1585.16 1577.56 1582.24 1582.34 1593.61 1586.5 1597.57 1581.28 1582.7 1582.77 1597.59 1597.6 1614.42 1614.21 1617.5 1616.64 1625.96 1622.7 1632.69 1623.09 1626.67 1623.71 1633.7 1626.74 1633.77 1633.75 1650.34 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. D. Winto an index Tunction in cell G4 that Tinas the closing value on this day using your answer to para What INDEX function should be used in cell G4 to find the closing value on this day used for the answer in parta? B E 1 S&P 500 Data 2 Day Day (April to May 2013) Open High Close 17 1574.57 1574,57 1543.69 155201 INDEX(A4E23,63,5) 1552.03 1554 38 1538.03 1541.61 G 8 3 Database row Low 4 5 18 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. 4 -INDEX(A4E23.03.5) way abuse (April to May 2013) Open High Low Close row 17 1574,57 1574,57 1543.69155201 18 1552.03 1554 381538.031541.61 19 1541.611555.80 1539.40 1555.25 5 6 Using this INDEX function in cell G4, the closing value on the day in part als (Type an Integer or a decimal. Do not round)