The accompanying data for the S&P provides open, high, low, and close values for the S&P index over a period of time. Complete parts a through below. E: Click the icon to view the S&P Index.
a Enter any day from June to July within the range of the data in cell G Use a MATCH function in cell G to find the row in the database that corresponds to this day. Day representing July has been added to cell G What MATCH function should be used in cell G to find the row in the database that corresponds to this day?
tableABCDEFGS&P Data,,,,,,Day,tableDayJune to July Open,High,Low,Close,tableDatabaserowvdots,vdots,vdots,vdots,vdots,,
