finance homwork questins1-4 - Microsoft Excel X Home Insert Page Layout Formulas Review View (?) * Cut Calibri Wrap Text Normal Bad Neutral Calculation Paste Copy Format Painter BIU BLA F Merge & Center % " $68 08 Conditional Format Explanatory ... Linked Cell Insert Delete Format Fill Clipboard Formatting * as Table Note 2 Clear Sort & Find & Font Alignment Number Filter . Select - Styles Cells Editing P16 0 S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price | COST Adj Close Price Q. W N N Source: Yahoo! Finance website 2/1/2015 $ 1,994.99 $ 30.34 $ 94.43 $ 36.39 $ 75.91 126.33 2,104.50 $ The Adj Close Price is adjusted for dividends and stock splits 32.84 103.78 39.50 3/1/2015 78.97 2,067.89 32.58 S 36.89 138.62 2,085.51 30.41 $ 97.25 130.88 6/1/2015 $ 2,107.39 $ 30.45 $ 101.28 $ 130.82 101.02 40.31 8 7/1/2015 $ 85.77 2,103.84 123.91 42.64 8/1/2015 $ 106.95 94.01 133.31 32.46 S 10 9/1/2015 $ 106.43 39.74 89.73 32.80 $ 128.49 105.54 40.68 $ 11 10/1/2015 $ 133.00 2,079.36 113.56 48.38 12 11/1/2015 $ 101.97 145.47 28.25 $ 122.97 49.96 $ 13 12/1/2015 27.07 $ 148.50 2,043.94 121.47 14 1/1/2016 $ 104.66 $ 148.96 25.02 $ 116.02 139.39 15 2/1/2016 $ 29.01 $ 112.21 $ 114.51 $ 106.92 $ ent 138.38 16 3/1/2016 $ 2,059.74 123.10 114.10 17 4/1/2016 $ 145.74 2,065.30 124.20 46.48 137.00 18 5/1/2016 $ 117.58 2,096.95 29.46 S 19 6/1/2016 $ 28.02 $ 122.56 49.39 138.00 114.28 $ 20 7/1/2016 $ 145.67 2,173.60 128.90 53.19 21 8/1/2016 $ 2,170.95 35.57 $ 123.94 125.06 53.93 22 9/1/2016 $ 150.35 2,168.27 35.29 $ 120.60 23 10/1/2016 $ 141.85 36.23 $ 114.35 56.59 24 11/1/2016 $ 2,198.81 42.55 $ ent 137.53 118.42 $ 139.62 12/1/2016 $ 126.33 59.08 115.05 149.37 26 1/1/2017 $ 2,278.87 41.71 S 129.63 61.46 130.32 152.96 11.34 136.53 60.83 28 3/1/2017 $ 165.30 2,362.72 138.34 156.87 29 4/1/2017 2,384.20 48.90 147.97 65.48 $ 30 5/1/2017 $ 150.25 56.05 $ 145.52 66.80 31 6/1/2017 2,423.41 168.79 54.11 $ 146.25 32 7/1/2017 $ 150.98 156.11 2,470.30 55.39 $ 142.63 33 8/1/2017 $ 169.25 154.72 2,471.65 $ 51.52 $ 34 9/1/2017 $ 171.97 $ 152.99 156.86 170.87 35 10/1/2017 $ 2,575.26 53.46 $ 158.99 36 11/1/2017 $ 180.06 157.73 2,584.84 81.40 37 12/1/2017 $ 172.46 177.18 180.60 2,673.61 $ 65.39 $ 83.14 $ 38 1/1/2018 $ 2,823.81 193.65 92.35 $ 2/1/2018 $ 186.89 191.39 69.56 $ 175.69 3/1/2018 $ 187.49 2,640.87 67.21 S 171.81 89.13 S 159.79 $ 185.56 Activate Windows 91.37 Go to Settings to activate Windows. Ready #0 100% O Type here to search [1)) 1/23/2020finance homwork questins1-4 - Microsoft Excel X Home Insert Page Layout Formulas Review View (?) * Cut Copy Calibri Wrap Text General Normal Bad Neutral Calculation E AutoSum Paste Format Painter BIU BLA 15 Merge & Center % " $68 08 Conditional Format Formatting * as Table Explanatory ... Input Linked Cell Note Insert Delete Format Fill Font 2 Clear Sort & Find & Clipboard Alignment Number Filter Select - Styles Cells Editing T56 28 3/1/2017 $ M 2,362.72 $ 46.04 $ N O P Q W 29 4/1/2017 138.34 $ 62.99 $ 142.05 $ 156.87 2,384.20 48.90 $ 30 5/1/2017 $ 147.97 5.48 150.25 166.06 56.05 $ 145.52 66.80 $ 31 6/1/2017 151.46 $ 2,423.41 168.79 54.11 $ 146.25 66.31 $ 32 7/1/2017 $ 150.98 156.11 2,470.30 55.39 $ 142.63 33 8/1/2017 $ 2,471.65 $ 69.25 $ 154.72 51.52 $ 142.89 71.93 $ 34 9/1/2017 $ 171.97 $ 54.08 $ 152.99 156.86 35 10/1/2017 $ 170.87 2,575.26 53.46 S 160.88 158.99 36 11/1/2017 $ 56.93 S 180.06 157.73 37 12/1/2017 $ 172.46 81.40 177.18 2,673.61 $ 65.39 $ 180.60 182.69 83.14 $ 38 1/1/2018 $ 176.46 $ 70.16 $ 2/1/2018 $ 2,823.81 193.65 92.35 $ 186.89 191.39 40 3/1/2018 5 69.56 $ 175.69 91.14 $ 2,640.87 178.32 187.49 67.21 $ 171.81 41 4/1/2018 $ 159.79 $ 185.56 73.96 $ 179.15 42 5/1/2018 $ 172.00 $ 2,705.27 65.96 $ 194.15 180.84 96.52 $ 43 6/1/2018 $ 191.78 $ 195.22 2,718.37 72.08 S 190.19 96.71 44 7/1/2018 $ 2,816.29 206.3 72.96 S 192.55 8/1/2018 $ 104.04 172.58 $ 216.00 45 2,901.52 46 9/1/2018 $ 195.72 110.17 $ 77.17 $ 175.73 $ 2,913.98 202.97 230.24 47 10/1/2018 $ 112.60 $ 2, 711.74 $ 232.55 68.62 48 11/1/2018 $ 172.33 105.16 $ 151.79 226.36 63.17 S 176.68 109.17 $ 49 12/1/2018 2,506.85 228.98 51.79 S 169.36 100.43 50 1/1/2019 $ 131.09 202.17 2,704.10 58.37 $ 180.90 51 2/1/2019 $ 103.26 $ 166.69 $ 67.83 $ 213.00 2,784.49 182.49 52 3/1/2019 $ 110.77 $ 161.45 70.02 S 217.08 189.14 53 4/1/2019 $ 166.69 240.95 73.84 $ 54 5/1/2019 $ 2,945.83 202.28 129.69 $ 193.40 244.33 2,752.06 62.19 6/1/2019 $ 188.53 122.81 S 2,941.76 $ 69.20 S 56 7/1/2019 $ 206.52 133.52 $ 193.00 $ 263.68 2,980.38 76.53 213.69 135.82 $ 194.23 $ 57 275.02 58 59 60 61 62 67 Activate Windows 68 4 4 Data File Go to Settings to activate Windows. Ready #:0 100% O Type here to search [1) 6 1/23/2020