Question: what is the Question b answer? D E a. Enter any day from July to August 2013 within the range of the data in cell

what is the Question b answer? what is the Question b answer? D E a. Enter any
D E a. Enter any day from July to August 2013 within the range of the data in cell G2. Use a MATCH function in cell G3 to find the row in the database that corresponds to this day Day 1 (representing August 1, 2013) has been added to cell G2. What MATCH function should be used in coll G3 to find the row in the database that corresponds to this day? A B C F G 1 S&P 500 Data 2 Day 1 3 Day Database (July to August 2013) Open High Low Close Tow =MATCH(G2 A4 A23,0) 12 1675 26 1680.19 1672.33 1680.19 15 1679.59 1684.51 1677.89 1682.50 16 1682.70 1683.731671 841676 26 6 Using this MATCH function in cell G3, day 1 returns the row 15 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 parta? A B D E F G 1 S&P 500 Data Day 1 Day Database (July to August 2013) Open High Low Close Tow 4 12 1675 26 1680.19 1672 33 1680.19 INDEX(A4E23.63,5) 5 15 1679.59 1684.51 1677 89 1682 50 6 16 1682 70 1683 73 1671.84 1676 26 3 .. WA 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) vo () More Enter your answer in the answer box and then click Check Answer part remaining Clear All

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 General Management Questions!