Using this MATCH function in cell G3, day 26 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 olosing value on this day used for the answer in par S\&P Index 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 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? The accompanying data for the SSP 800 provides open, high, low, and close values for the SBP index over a period of time, Complete parts a through o below. Click the icon to view the SBP Index. a. Enter any day from July to August 2013 within the range of the date in coll 02 Use a MATCH function in cell 03 to fnd the row in the database that corresponds to this day Day 20 (representing July 26, 2013) has been added to oet 62 . What MATCH functon should be used in cell G3 to find the row in the database that corresponds to this day? Using this MATCH function in cell G3, day 26 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 olosing value on this day used for the answer in par S\&P Index 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 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? The accompanying data for the SSP 800 provides open, high, low, and close values for the SBP index over a period of time, Complete parts a through o below. Click the icon to view the SBP Index. a. Enter any day from July to August 2013 within the range of the date in coll 02 Use a MATCH function in cell 03 to fnd the row in the database that corresponds to this day Day 20 (representing July 26, 2013) has been added to oet 62 . What MATCH functon should be used in cell G3 to find the row in the database that corresponds to this day