Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The accompanying data for the S&P 500 provides open, high low, and close values for the S&P index over a period of time Complete parts

image text in transcribed
image text in transcribed
The accompanying data for the S&P 500 provides open, high low, and close values for the S&P index over a period of time Complete parts a through c below. Click the icon to view the S&P Index 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 20 (representing May 20, 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? G 20 A B D E F 1 S&P 500 Data 2 Day 3 Day Database (May to June 2013) Open High Low Close row 4 9 1632.69 1635.011623.09 1626.67 5 10 1626.69 1633.701623.71 1633.70 6 13 1632.101636.00 1626.74 1633.77 =MATCH(G2,A4 A23,0) Using this MATCH function in cell G3, day 20 returns the row Vi vi More Enter your answer in the answer box and then click Check Answer. 3 parts Clear All Check Answer remaining data120200 vlev data-019 2020-9 yisy Show all B D E F G A 1 S&P 500 Data 2. #N/A 3 Day (May to June 2013) Open High Low Close 1632.69 1635.01 1623.09 1626.67 5 10 1626.69 1633.7 1623.71 1633.7 6 13 1632.1 1636 1626.74 1633.77 7 14 1633.75 1651.1 1633.75 1650.34 8 15 1649.13 1661.49 1646.68 1658.78 9 16 1658.07 1660.51 1648.6 1650.47 10 17 1652.45 1667.47 1652.45 1667.47 11 20 1665.71 1672.84 1663.52 1666.29 12 21 1666.2 1674.93 1662.67 1669.16 13 22 1669.39 1687.18 1648.86 1655.35 14 23 1651.62 1655.5 1635.53 1650.51 15 24 1646.67 1649.78 1636.88 1649.6 16 28 1652.63 1674.21 1652.63 1660.06 17 29 1656.57 1656.57 1640.05 1648.36 18 30 1649.14 1661.91 1648.61 1654.41 19 31 1652.13 1658.99 1630.74 1630.74 20 3 1631.71 1640.42 1622.72 1640.42 21 4 1640.73 1646.53 1623.62 1631.38 x 22. 5 1629.05 1629.31 1607.09 1608.9 23 6 1609.29 1622.56 1598.23 1622.56 ? 24 25 Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions