Sater to stay in Protected View. Enable Editing A7 X fx START K M B C D E F G H 1 The Blue Chips: The Dow Jones Industrial Average (DJIA) J 2 The Dow Jones is a list of 30 of the largest companies in the United States. NUM TICKER COMPANY INDUSTRY 3 Because of the sizes of the changes in these companies is so significant, 1 MMM 3M 4 they are reported on a daily basis, and used to judge the overall strength of Conglomerate 2 AXP American Express Financial Services 5 the US economy. 3 AAPL Apple Information Technology 6 7 There are 10 questions below the data table. To assist in answering the questions, FILTER the data. 8 If this has not already been done. Select the data from A13 to 143. Click on the menu item Data, at the top of the screen. Then click FILTER. 9 Each column will have a down arrow, allowing you to select ONLY the data you are looking for. For example, if you want only those companies in the Financial 10 Services industry, you can select that data item from the dropdown. OR, you could tiptoe using your fingers! See questions beneath the table. 11 12 MILLIONS MILLIONS MILLIONS SHARE 13 TICKER - COMPANY INDUSTRY SALES - INCOME SHARES - EPS PRICE - P/E RATIC 14 MMM 3M Conglomerate $32,765 $5,363 576.57 $9.30 $206.57 22 15 AXP American Express Financial Services $36,986 $6,921 847 $8.17 $107.00 13 16 AAPL Apple Information Technology $265,595 $59,531 4720 $12.61 $170.89 14 17 BA Boeing Aerospace & Defense $94,005 $8,458 565 $14.97 $410.72 27 18 CAT Caterpillar Construction & Mining Equipment $54,772 $6,147 590 $10.42 $132.67 13 19 CVX Chevron Oil & Gas $158,902 $14,824 1,910 $7.76 $118.72 15 20 CSCO Cisco Information Technology $49,330 $110 450 $0.24 $47.89 196 21 KO Coca-Cola Food $35,410 $1,248 4260 $0.29 $49.66 170 22 DIS Disney Broadcasting & Entertainment $59,434 $12,598 1490 $8.46 $109.20 13 23 DWDP DowDupont Inc. Chemicals $62,484 $1,460 2270 $0.64 $53.36 83 24 XOM Exxon Mobil Oil & Gas $290,212 $20,840 4240 $4.92 $75.40 15 25 GS Goldman Sachs Financial Services $35,942 $9,841 381 $25.83 $194.49 8 26 HD Home Depot Retail $100,904 $8,630 1130 $7.64 $185.52 24 27 IBM IBM Information Technology $79,591 $8,278 909 $9.11 $136.05 15 28 INTC Intel Information Technology $70,848 $21,053 4500 $4.68 $50.01 11 29 JNJ Johnson & Johnson Pharmaceuticals $81,581 $15,297 2680 $5.71 $134.16 24 30 JPM JP Morgan Chase Financial Services $104,158 $32,474 3320 $9.78 $102.60 10 31 MCD McDonald's Food $22,820 $5,192 771 $6.73 $173.97 26 32 MRK Merck Pharmaceuticals $42,294 $6,220 2600 $2.39 $78.52 33 33 MSFT Microsoft Information Technology $110,360 $33,540 7670 $4.37 $106.89 24 34 NKE Nike Apparel $36,397 $1,933 1260 $1.53 $84.71 55 35 PFE Pfizer Pharmaceuticals $53,647 $11,153 5780 $1.93 $41.87 22 ARAN Dow Jones-30 Ready 1 M H $1.93 $3.90 $9.57 $6.11 22 25 13 20 D Pfizer Pharmaceuticals Procter & Gamble Consumer Goods Travelers Companies Inc. Insurance United Technologies Conglomerate United Health Health Care Verizon Telecommunications VISA Financial Services Wal-Mart Retail Walgreens Boots Alliance Retail E $53,647 $66,832 $30,282 $66,501 $226,247 $130,863 $20,609 $500,343 $131,587 F $11,153 $9,750 $2,523 $5,269 $11,986 $15,528 $10,301 $9,862 $5,024 B 35 PFE 36 PG 37 TRV 38 UTX 39 UNH 40 VZ 41 V 42 WMT 43 WBA 44 45 46 47 48 49 50 51 52 G 5780 2500 263.6 861.75 962.03 4130 1750 2910 943,44 $12.46 $41.87 $99.26 $127.26 $123.98 $263.50 $54.42 $141.99 $96.97 $1.56 21 14 24 $3.76 $5.89 $3.39 $5.33 29 0 QUESTIONS Answers go in this column 1 The Dow Jones list contains 4 companies in the financial services category. Which one of those had the highest sales level in 2018? Hint: Click on the down-arry symbol for Industry Click the Select All to turn it off. Click on Financial Services and hit the OK button. Look at the data and choose the correct company. Click on the answer column to choose your answer. Each correct answer scores a 1 in the Score column. To return to the full list, click on the filter symbol and choose Select All. 53 54 2 Which company in the Financial Services industry had the highest Earnings Per Share (EPS)? 55 56 3 Which company in the 30 had the highest share price? 57 4 Which company in the Dow Jones 30 had the highest level of revenue? 58 59 5 Which company in the Information Technology Industry had the highest Earnings Per Share (EPS)? 60 61 6 Which company in the Information Technology Industry had the highest share price? 62 63 7 Which of the two companies in the Oil and Gas Industry has the highest sales? 64 65 8 In the Pharmaceuticals Industry, which company has the highest Earnings Per Share (EPS)? 66 67 68 9 Which company in the list has the most shares outstanding? Hint: it is in the Information Technology Industry, 69 10 Which company has the highest Price to Earnings Ratio (PE or P/E), making it (theoretically, the most expensive stock? Dow Jones-30 Ready