(Solved): The accompanying data for the S\&P 500 provides open, high, low, and close values for the S\&P ind ...

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 S8P index. Using this MATCH function in cell G3, day 8 returns the row b. Write an INDEX function in cell G4 that finds the dosing 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? Using this INDEX function in coll G4, the clobing value on the day in part a is The accompanying data for the S\$P 500 prowdes open, high, low, and close values for the SsP index over a period of time. Complete parts a through c below. Cick the foon to view the SsP Index. a. Enter any day from July to August 2013 within the range of the data in cel G2. Use a MhTCH function in cell G3 to find the row in the database that corresponds to this dsy. Day 8 (representing August 8, 2013) has beon added to cell G2. What MATCH function should be used in cel G3 to find the row in the database that corresponds to this day? Using this MATCH function in cell G3, day at refums the row b. Whte an NDEX Aunction in cell \( G 4 \) that finds the closing value on this day using your answer to part a What iNDEX turcion should be used in cel G4 to find the dosing value on this day used for the answer in pat a?