Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|c|c|} hline 3 & Day(MaytoJune2013) & Open & High & Low & Close hline 4 & 10 & 1626.69 & 1633.70 & 1623.71 &
\begin{tabular}{|c|c|c|c|c|c|} \hline 3 & Day(MaytoJune2013) & Open & High & Low & Close \\ \hline 4 & 10 & 1626.69 & 1633.70 & 1623.71 & 1633.70 \\ \hline 5 & 13 & 1632.10 & 1636.00 & 1626.74 & 1633.77 \\ \hline 6 & 14 & 1633.75 & 1651.10 & 1633.75 & 1650.34 \\ \hline 7 & 15 & 1649.13 & 1661.49 & 646.68 & 1658.78 \\ \hline 8 & 16 & 1658.07 & 1660.51 & 1648.60 & 1650.47 \\ \hline 9 & 17 & 1652.45 & 1667.47 & 652.45 & 1667.47 \\ \hline 10 & 20 & 1665.71 & 1672.84 & 1663.52 & 1666.29 \\ \hline 11 & 21 & 1666.20 & 1674.93 & 1662.67 & 1669.16 \\ \hline 12 & 22 & 1669.39 & 1687.18 & 648.86 & 1655.35 \\ \hline 13 & 23 & 1651.62 & 1655.50 & 1635.53 & 1650.51 \\ \hline 14 & 24 & 1646.67 & 1649.78 & 1636.88 & 1649.60 \\ \hline 15 & 28 & 1652.63 & 1674.21 & 1652.63 & 1660.06 \\ \hline 16 & 29 & 1656.57 & 1656.57 & 1640.05 & 1648.36 \\ \hline 17 & 30 & 1649.14 & 1661.91 & 1648.61 & 1654.41 \\ \hline 18 & 31 & 1652.131658 .99 & 1630.74 & 1630.74 \\ \hline 19 & 3 & 1631.71 & 1640.42 & 1622.72 & 1640.42 \\ \hline 20 & 4 & 1640.731646 .53 & 1623.62 & 1631.38 \\ \hline 21 & 5 & 1629.05 & 1629.31 & 1607.09 & 1608.90 \\ \hline 22 & 6 & 1609.29 & 1622.56 & 1598.23 & 1622.56 \\ \hline 23 & 7 & 1625.27 & 1644.40 & 1625.27 & 1643.38 \\ \hline \end{tabular} 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? a. Enter any day from May to June 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 21 (representing May 21, 2013) has been added to cell G2. What MATCH function 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 21 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 closing value on this day used for the answer in part a? 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started