Answered step by step
Verified Expert Solution
Link Copied!

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 &

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

\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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Top Accounting And Auditing Issues For 2023

Authors: CCH Tax Law Editors

1st Edition

0808059335, 978-0808059332

More Books

Students also viewed these Accounting questions

Question

How well is Alexander Forbes aligned with industrial 4.0

Answered: 1 week ago

Question

1. Understand how verbal and nonverbal communication differ.

Answered: 1 week ago