bis subject

This assignment requires that students know how to use Excel to enter data, insert formulas, develop graphs, format the final sheet. 1. Enter the data into Excel (attached); 2. Enter the appropriate formulas; 3. Format the final sheet according to the instructions; 4. Submit a summary of one page that presents a recommendation and supporting data (including methods of analysis) for this assignment, use the attached Blue Chip Stock club Investment Analysis sheet. Investment Analysis Sheet3 e Chip Stock Club vestment Analysis Initial Date Initial Stock Symbol Acquired Shares Price Per Share Cost 3M MMM 12/6/18 394 79.75 Caterpillar CAT 15/3/20 750 34.25 Coca-Cola KO 1/8/18 975 58.75 DuPont DD 12/9/18 850 33.125 General Electric GE 8/12/16 525 29.52 General Motors GM 5/10/19 810 37.375 Intel INTC 3/10/20 875 13 Microsoft MSFT 15/1/19 250 64.35 Wal-Mart WMT 9/7/19 925 32.625 Total Average Highest Lowest