Question: b . Write an INDEX function in cell G 4 that finds the closing value on this day using your answer to part a .

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?
\table[[,A,B,C,D,E,F,G],[1,S&P 500 Data,,,,,,],[2,,,,,,Day,10],[3,\table[[Day],[(April to May 2013)]],Open,High,Low,Close,\table[[Database],[row]],],[4,26,1585.16,1585.78,1577.56,1582.24,,]]
 b. Write an INDEX function in cell G4 that finds the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!