60.1K

Verified Solution

Link Copied!

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 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 cell G3 to find the row in the database that corresponds to this day D A 1 S P 500 Data 2 3 4 5 6 B 22 23 24 C E F Day Database Day July to August 2013 Open High Low Close row 1694 41 1697 61 1690 67 1695 53 1696 63 1698 78 1691 13 1692 39 1696 06 1698 381682 57 1685 94 G MATCH G2 A4 A23 1 MATCH G2 A4 E23 1 MATCH G3 B4 B23 0 Day July to August 2013 High Close 1697 61 1690 67 1695 53 Open 22 1694 41 23 1696 63 1698 78 1691 13 1692 39 24 1696 06 1698 38 1682 57 1685 94 25 1685 21 1690 94 1680 07 1690 25 26 1687 31 1691 85 1676 03 1691 65 29 1690 32 1690 92 1681 86 1685 33 30 1687 92 1693 19 1682 42 1685 96 31 1 2 5 6 1687 76 1698 43 1684 94 1685 73 1689 42 1707 85 1689 42 1706 87 1706 1 1709 67 1700 68 1709 67 1708 01 1709 24 1703 55 1707 14 1705 79 1705 79 1693 29 1695 3 1695 3 1684 91 1693 35 1700 18 1688 38 1696 1 1699 42 1686 02 1688 37 1691 49 1683 35 1690 65 1696 81 1682 62 1697 37 1690 91 1697 48 1691 42 1689 47 1694 16 1685 39 1693 88 1695 52 1684 83 1679 61 1679 61 1658 59 1661 32 16 1661 22 1663 6 1652 61 1655 83 7 8 9 12 13 14 15 Low

Answer & Explanation Solved by verified expert

See Answer