2. Create a chart for each company using the appropriate stock chart sub-type. Place the Wal-Mart chart on the Wal-Mart worksheet, the Time Warner chart on the Time Warner worksheet, etc. Make sure that the charts are easy to read (i.e. you should make them bigger!). Use the following information to help you create the four charts: Wal-Mart Chart Use the High-Low-Close Sub-Type. Chart Title = Wal-Mart (in bold). Display the Legend on the Right. Vertical Axis Minimum = 58; Vertical Axis Maximum = 70. Format the Close Markers to Size 8. Time Warner Chart Use the Open-High-Low-Close Sub-Type. Chart Title = Time Warner (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 16.5; Vertical Axis Maximum = 19.5. AMD Chart Use the Volume-High-Low-Close Sub-Type. Chart Title = AMD (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 30000000. Secondary Vertical Axis Minimum = 0; Secondary Vertical Axis Maximum = 25. Volume Columns: Fill = Solid Fill; Color = Light Blue (the exact shade of blue does not matter). Excel 8 IST 310: Introduction to Information and Management Productivity Systems Page 2 Intel Chart Use the Volume-Open-High-Low-Close Sub-Type. Chart Title = Intel (in bold). Display the Legend on the Right. Vertical Axis Minimum = 0; Vertical Axis Maximum = 120000000. Secondary Vertical Axis Minimum = 25; Secondary Vertical Axis Maximum = 32. Volume Columns: Fill = Solid Fill; Color = Light Red (the exact shade of red does not matter).

3. On the Stock Comparison worksheet, create a line chart that compares all four stocks on the same chart. Use the following information to help you create the chart: Time Period in Chart = January 1, 2015 - December 31, 2015. Chart Title = Stock Price Comparison (in bold). Display the Legend on the Bottom. Vertical Axis Minimum = 0; Vertical Axis Maximum = 80.

4. On the Portfolio worksheet, create a chart to display the relative contribution of each stock to the value of the portfolio. Before creating the chart, sort the data from largest to smallest by value. Your chart should look very similar to the one displayed below (the colors do not have to match). Excel 8 IST 310: Introduction to Information and Management Productivity Systems Page 3

5. Create a Combo Chart on the Intel Summary worksheet that shows the daily closing price and volume data. Include the data from January 1, 2015 - to January 31, 2016. Add a linear trend line and a 30-day moving average trend line to the chart. Your chart should look very similar to the one displayed below (the colors do not have to match).

6. Make the Wal-Mart tab the active worksheet, save and close your file, and use the Excel 8 link on Blackboard to submit your work.

A 1 Date 2 3-Mar-16 64.31 3 4-Mar-16 63.71 4 5-Mar-16. 63.55 5 6-Mar-16 63.70 6 7-Mar-16 64.74 7 10-Mar-16 65.24 8 11-Mar-16 65.18 9 65.45 12-Mar-16 13-Mar-16 10 65.38 11 14-Mar-16 64.20 12 17-Mar-16 64.47 13 18-Mar-16 63.99 14 19-Mar-16 63.92 15 20-Mar-16 64.14 16 21-Mar-16 63.37 17 24-Mar-16 62.07 18 25-Mar-16 62.72 19 26-Mar-16 61.72 20 27-Mar-16 62.76 21 28-Mar-16 63.60 22 31-Mar-16 63.38 23 1-Apr-16 63.92 24 2-Apr-16 62.50 25 3-Apr-16 63.65 26 4-Apr-16 63.63 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 B Open Wal-Mart C High D Low 66.46 63.27 65.79 62.28 66.12 62.69 66.82 62.95 67.44 64.02 67.43 64.17 67.98 64.53 67.74 64.72 67.55 64.39 67.12 62.87 67.63 63.09 66.66 62.91 66.43 63.20 66.11 62.71 65.34 60.76 64.58 61.46 64.77 60.96 64.65 61.02 65.34 61.80 66.01 62.47 66.01 62.70 66.52 62.87 65.88 61.90 66.01 62.46 66.48 62.84 Time Warner F Volume 65.28 9682956 64.72 9803808 64.84 10071432 65.25 10293156 66.64 11927736 66.18 7417440 66.98 9094464 66.84 6988356 66.49 9150192 65.00 15654384 65.28 11475540 65.32 9095544 65.75 7454808 64.59 11216448 63.15 15904404 63.87 7735176 62.90 14200164 63.96 10876248 64.37 9377640 65.10 9558648 65.02 7847496 64.72 8817876 65.00 7064280 65.28 10870740 65.69 6908760 E Close AMD Intel G H I Stock Comparison J Portfolio K M Intel Summary L + N O X fx Date A C 1 Date B Open 18.00 High 2 3-Mar-16 3 4-Mar-16 17.82 4 5-Mar-16 17.53 5 6-Mar-16 17.60 6 7-Mar-16 17.50 7 10-Mar-16 17.89 8 11-Mar-16 17.87 9 12-Mar-16 17.93 10 13-Mar-16 17.93 11 14-Mar-16 17.96 12 17-Mar-16 18.25 13 18-Mar-16 18.24 19-Mar-16 18.39 14 15 20-Mar-16 18.37 16 21-Mar-16 18.54 17 24-Mar-16 18.45 18 25-Mar-16 18.28 19 26-Mar-16 17.69 20 27-Mar-16 17.72 21 28-Mar-16 17.88 22 31-Mar-16 17.71 23 1-Apr-16 17.94 24 2-Apr-16 17.76 25 3-Apr-16 17.73 26 4-Apr-16 17.82 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 A1 Dub Wal-Mart D Low 18.66 18.34 18.06 18.16 18.52 18.55 18.55 18.63 18.64 18.63 19.11 18.94 19.10 19.03 19.22 19.17 18.95 18.40 18.32 18.40 18.50 18.70 18.43 18.70 18.45 Time Warner 17.60 17.14 17.14 17.16 17.33 17.63 17.65 17.67 17.71 17.76 17.90 17.93 18.09 17.98 18.14 18.22 17.61 17.38 17.40 17.45 17.49 17.57 17.38 17.55 17.51 E Close F Volume 18.33 22319280 17.76 16410816 17.75 14096052 17.79 19443456 18.28 15653628 18.19 9909000 18.31 11353608 18.26 13213692 18.23 16149348 18.35 12248604 18.63 14336568 18.73 10931004 18.82 12053556 18.61 10366920 18.81 13219956 18.79 10898064 18.28 21315420 18.10 15424020 18.06 11361492 12814416 17.99 18.19 10340892 18.13 11312028 18.16 14201136 18.32 21049416 18.20 11101428 AMD Intel G H I Stock Comparison J K Portfolio M Intel Summary L + N AI Name Box B C D E F 1 Date Open High Low Close Volume 2 3-Mar-16 16.1999 17.0212 15.9376 16.4929 8785476 3 4-Mar-16 15.9665 16.4316 15.3072 15.9954 10484748 4 5-Mar-16 15.9878 16.4753 15.4648 16.0711 12602628 5 6-Mar-16 15589368 15.765 16.9666 16.6031 17.4142 16.3789 15.4543 16.8065 17.1634 6 7-Mar-16 13414032 7 10-Mar-16 16.7092 17.3378 16.1792 16.7741 15149808 8 11-Mar-16 16.6243 9 10 15567984 11783988 17.3159 16.4104 17.012 8524008 12-Mar-16 16.55 17.5452 16.1267 17.3364 11666376 13-Mar-16 17.0062 17.9055 16.547 17.5527 13204188 11 14-Mar-16 17.2715 18.4514 17.0828 18.1584 14679900 12 17-Mar-16 18.1838 19.0956 17.8707 18.8722 13 18-Mar-16 18.3005 19.1065 18.0913 18.8505 14 19-Mar-16 18.2475 18.779 17.7026 18.4937 13075884 15 20-Mar-16 18.0353 18.6479 17.5555 18.2774 11125620 16 21-Mar-16 18.2899 18.8336 17.7341 18.3855 7544340 17 24-Mar-16 18.1626 18.9755 17.8602 18.7857 6943644 18 25-Mar-16 18.5658 19.2157 18.0178 18.5585 18005544 19 26-Mar-16 17.7701 19.0192 17.5976 18.5153 13781880 20 27-Mar-16 18.1626 18.779 16.61 17.5419 26910684 21 28-Mar-16 17.2078 17.7854 16.547 17.3581 10870092 22 31-Mar-16 17.0805 17.8182 16.8621 17.6176 23 1-Apr-16 17.4518 18.0693 16.568 17.0769 2-Apr-16 16.9107 17.8182 16.4209 11549304 7863696 24 17.6068 17283132 25 3-Apr-16 17.1123 18.1457 16.652 17.8015 8368704 26 4-Apr-16 17.6109 18.2767 17.0197 17.6933 8011332 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Time Warner AMD Intel Ready Wal-Mart Jx Date G H I Stock Comparison J Portfolio K M Intel Summary L + A1 fx Date A B D Date Open High Low 29.8826 27.7148 3-Mar-16 28.6973 4-Mar-16 27.8592 28.9218 27.3471 28.3677 28.1139 29.1511 27.4207 28.292 27.8168 29.3367 27.4837 28.6922 7-Mar-16 28.5382 30.352 10-Mar-16 29.4718 30.4066 5-Mar-16 6-Mar-16 28.2191 30.0549 28.7024 29.6115 X E F 1 Close Volume 2 28.6489 90433472 3 78846912 4 75835328 5 75061512 6 91534968 7 70895844 8 11-Mar-16 29.3339 30.5158 28.8915 29.9467 71549460 30.0682 28.4713 29.6655 67166496 9 12-Mar-16 29.1005 10 13-Mar-16 29.0899 29.9917 28.3872 29.4168 62434044 11 14-Mar-16 29.0368 30.3302 28.6604 29.6115 59456052 84965976 51337476 14 75759840 15 12 17-Mar-16 29.7052 30.7014 29.0491 30.4118 13 18-Mar-16 30.0235 31.1818 29.5429 30.8768 19-Mar-16 29.9704 31.0617 29.4588 30.574 20-Mar-16 29.7901 30.7123 28.8705 29.871 78494832 16 21-Mar-16 29.7901 30.7233 28.5763 29.6007 77534928 17 24-Mar-16 29.3869 30.3193 28.6078 29.8494 55098252 18 25-Mar-16 29.5673 30.4394 28.8285 29.9251 89818096 26-Mar-16 28.8671 19 30.1446 28.5028 29.6007 85548640 20 27-Mar-16 29.0793 29.9372 27.9144 28.8328 97739024 21 28-Mar-16 28.3897 29.2821 27.5888 28.6057 69017616 22 29.1947 27.6308 28.8544 55644516 23 24 31-Mar-16 28.0184 1-Apr-16 28.3154 29.3803 27.3471 28.1947 54659232 2-Apr-16 27.7213 28.9327 27.137 28.4218 66916800 3-Apr-16 27.5516 29.2057 27.158 28.6814 70378740 4-Apr-16 28.4321 30.1009 27.9985 29.7737 70421292 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Time Warner AMD Intel Wal-Mart G H I Stock Comparison J Portfolio K L M Intel Summary + N O A1 A 1 2 Date 3 1-Jan-15 4 2-Jan-15 5 3-Jan-15 6 4-Jan-15 7 5-Jan-15 8 8-Jan-15 9 9-Jan-15 10 10-Jan-15 11 11-Jan-15 12 12-Jan-15 13 15-Jan-15 14 16-Jan-15 15 17-Jan-15 16 18-Jan-15 17 19-Jan-15 18 22-Jan-15 19 23-Jan-15 20 24-Jan-15 21 25-Jan-15 22 26-Jan-15 23 29-Jan-15 24 30-Jan-15 25 31-Jan-15 26 1-Feb-15 2-Feb-15 27 28 5-Feb-15 29 6-Feb-15 30 7-Feb-15 31 8-Feb-15 32 33 9-Feb-15 12-Feb-15 34 13-Feb-15 35 14-Feb-15 36 15-Feb-15 37 16-Feb-15 38 19-Feb-15 39 20-Feb-15 40 21-Feb-15 41 22-Feb-15 42 23-Feb-15 43 26-Feb-15 44 27-Feb-15 fx Closing Prices B C D E Closing Prices AMD Intel Wal-Mart Time Warner 57.48 14.39 7.5813 18.0502 55.70 14.71 7.5056 17.888 55.91 15.24 7.7435 18.5802 56.21 15.31 7.7544 18.7748 55.69 15.01 7.2352 18.0394 57.84 15.50 7.4732 18.4504 16.09 8.0139 18.8397 16.25 8.0572 18.7965 16.60 8.0355 19.2399 16.48 8.0572 18.764 16.55 7.7868 18.6018 16.02 6.5214 17.6717 15.52 6.489 17.6176 15.04 6.1862 17.5744 15.66 6.1105 18.0286 57.50 57.12 57.27 56.35 56.03 55.66 54.59 53.55 54.10 52.69 52.47 53.67 53.58 52.99 53.25 53.55 52.52 52.07 52.12 52.12 52.38 15.26 5.8725 17.1418 14.68 5.7103 17.1742 14.77 5.732 17.3364 15.10 6.0672 18.0178 12.98 5.5914 17.0661 12.61 5.6671 16.9363 12.49 5.4616 17.0661 11.97 5.4724 16.9147 11.37 5.4399 16.8498 11.72 5.4832 16.6659 11.51 5.4508 16.2766 11.20 5.5914 16.5145 11.03 5.494 16.5902 52.63 53.30 11.11 5.3426 16.3847 53.07 10.98 5.4075 16.7957 54.75 11.37 5.5157 17.4662 54.67 11.97 5.9266 18.0935 11.83 6.0348 18.1476 54.33 53.56 54.47 53.07 11.42 5.7644 18.3422 11.46 5.8293 18.1584 10.88 5.7428 17.888 53.95 11.28 5.6779 18.0935 11.11 5.5697 17.5636 11.62 5.6562 18.0611 53.28 53.65 53.54 53.24 52.24 12.24 5.9374 18.6559 12.11 5.8077 18.0178 11.76 5.6887 17.9745 Time Warner AMD Wal-Mart F Intel G H I Stock Comparison J Portfolio K L M Intel Summary + N A1 A 1 Name ALBERT INC 2 3 AMER EXPRESSO CO 4 AMER GROUP 5 BOETERING CO 6 CARSONS INC 7 CITY INC 8 DU PAGE CO 9 GENERAL AIR CO 10 GENERAL MICRO 11 HEWLETT-GEORGE 12 HOME WORKS INC 13 HONEY-BART INTL 14 INTELLIGENT CORP 15 INTL BUS CO 16 JQ RANDOLPH 17 SMITH&SMYTHE 18 WALT DOWNS CO 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Wal-Mart Jx B Symbol AB AP AG BT CR CT DU GA GM HG HW HON IN IBC JQR SS DWS Name C Last 33.5 51.5 75.6 44.7 83.8 50.6 45.8 31.7 51.5 22.3 37.6 36 28.1 93.9 39.8 55.4 25.2 E Value 55 $ 1,840.30 600 $30,876.00 1200 $ 90,696.00 527 $ 23,535.82 79,562.50 950 $ 800 $ 40,440.00 100 $ 4,581.00 21,417.75 675 $ 200 $ 2000 $ 102,920.00 4,466.00 1100 $ 41,316.00 100 $ 3,596.00 500 $14,045.00 800 $75,088.00 750 $ 29,850.00 1000 $ 55,360.00 800 $ 20,128.00 $ 639,718.37 AMD D Shares Time Warner F Intel G H T Stock Comparison J Portfolio K L Intel Summary M + N O A1 X fx Date A B D E F 1 Date Open High Low Close Volume 2 1-Jan-15 16.9956 18.2658 16.4524 18.0502 61706124 3 2-Jan-15 17.6852 18.3968 17.1668 17.888 54293436 61683660 4 5 6 3-Jan-15 17.717 19.0628 17.44 18.5802 4-Jan-15 18.5764 19.2703 17.8602 18.7748 68961996 5-Jan-15 18.2157 18.8881 17.4295 18.0394 60177492 8-Jan-15 17.908 18.9755 17.7131 18.4504 63388332 9-Jan-15 18.0777 19.1065 17.7131 18.8397 59395032 72214416 7 8 9 10-Jan-15 18.9371 19.6306 18.1018 18.7965 10 11 11-Jan-15 18.6294 19.4777 18.2174 19.2399 87007712 12-Jan-15 19.0325 19.6633 18.2174 18.764 107735400 12 15-Jan-15 18.5127 19.1393 17.9758 18.6018 58773924 13 16-Jan-15 17.9186 18.506 17.1038 17.6717 73401120 14 61993836 15 17-Jan-15 17.2608 18.113 17.0512 17.6176 18-Jan-15 17.1972 18.2221 16.9672 17.5744 19-Jan-15 17.5367 18.3204 17.0092 18.0286 56105028 64982844 16 19 20 24 25 26 51143616 27 53501148 28 57215376 29 17 22-Jan-15 17.4412 18.0038 16.547 17.1418 65698344 18 23-Jan-15 16.4333 17.6107 16.2633 17.1742 61084476 24-Jan-15 17.0805 17.7745 16.5995 17.3364 63058176 25-Jan-15 16.9107 18.2221 16.4944 18.0178 68083848 21 26-Jan-15 17.6428 18.2331 16.5575 17.0661 59980716 22 29-Jan-15 16.3273 17.305 15.9061 16.9363 70889148 23 30-Jan-15 16.6031 17.447 16.2843 17.0661 47275920 31-Jan-15 16.5182 17.2286 16.1057 16.9147 44352468 1-Feb-15 16.7304 17.6326 16.2843 16.8498 54952452 2-Feb-15 16.4333 17.1522 16.0322 16.6659 5-Feb-15 16.4758 17.0648 15.6434 16.2766 6-Feb-15 15.9878 16.8683 15.6329 16.5145 7-Feb-15 16.3273 16.9557 15.822 16.5902 51031512 8-Feb-15 16.2106 16.8356 15.8746 16.3847 41474160 9-Feb-15 16.2636 17.0321 15.8641 16.7957 58995648 12-Feb-15 16.6349 17.6872 16.3158 17.4662 59130000 13-Feb-15 17.4094 18.2877 16.9987 18.0935 54540648 34 14-Feb-15 18.0247 18.6261 17.3349 18.1476 55937304 35 15-Feb-15 18.1202 18.6698 17.6711 18.3422 56292948 36 16-Feb-15 18.0777 18.6152 17.2509 18.1584 66249468 37 19-Feb-15 17.6958 18.6698 17.3559 17.888 53074980 38 20-Feb-15 17.2821 18.3313 16.8096 18.0935 21-Feb-15 17.5261 18.3968 16.9252 17.5636 57686256 22-Feb-15 17.3775 18.3095 17.1248 18.0611 54312876 41 23-Feb-15 18.0141 18.8772 17.6606 18.6559 70469352 42 26-Feb-15 18.1732 18.8991 17.4189 18.0178 30 31 32 33 63188424 39 40 62936244 43 27-Feb-15 17.7064 18.4623 17.3139 17.9745 54842184 44 28-Feb-15 17.6746 18.6589 17.44 18.3639 53284176 Wal-Mart Time Warner AMD G Intel H I J Stock Comparison K Portfolio L M Intel Summary N +