Excel Help

1) Which two stocks have the highest price-stability in the last 52-weeks? Price-stable stocks have less percentage price changes (ex: HD, MSFT)

2) What is the weight of MSFT stock in Dow30, based on Marketcap? (ex: 12.34%)

This excel is based on the Dow 30 stocks ( i need to know how to get the answer for both questions, Please explain the process to get the answer)

SON B C D 1 E Ticker - Company Name - Last Traded H M Shares Traded (mil) - Shares Out (mil) - Market Cap ($bil) - P/E - EPS 52-wk Hiwk to Column 12 - Most Active - X52-wk Hi-552-wk to - Columns 2 BABA Alibaba Group Holding Ltd - ADR 9/30/2020 16:00 S 293.98 3 PG 24.68 Procter & Gamble Co 21645.09 $6,363 9/30/2020 16:02 S 30.54 $ 9.63 S 299.00 $ 161.68 0.11% 138.99 8.73 96% 1825 4 MCD Mcdonald's Corp 2489.62 $346 28.02 $ 4.96 $ 141.70 S 94.34 9/30/2020 16:00 $ 9995 219.49 0.35% 3.03 147% 5 UNH United Health Group Inc 744.1 $163 34.8 $ 6.31 $ 226.72 $ 124.23 9/30/2020 16:00 $ 0.41 97% 177% 311.77 3.47 950.34 6 VZ Verizon Communications Inc. $296 0.36% 17.53 $17.78 $ 324.57 $ 187.72 9/30/2020 16:00 $ 96% 156% 59.49 16.35 4138.05 7 CAT $246 Caterpillar Inc 12.86 $ 4.62 $ 62.22 $ 48.84 0.40% 95% 9/30/2020 16:00 $ 127 149.15 3.64 541.51 BJNJ 581 20.01 $ 7.45 $ 156.25 S Johnson & Johnson 87.50 0.67% 95% 170 9/30/2020 16:00 $ 148.88 8.48 2632.82 $392 26.18 $ 5.59 $ 157.00 $ 109.16 9 HD 0.32% % Home Depot Inc 95% 136% 9/30/2020 16:00 S 277.71 4.78 1076.46 $299 25.44 $10.92 $ 292.95 $ 140.63 10 WMT Walmart Inc 0.44% 95% 197% 9/30/2020 16:00 $ 139.91 11.59 2833.75 $396 22.3 $ 6.27 $ 151.33 $ 102.00 92% 11 v 0.41% 137% Visa Inc 9/30/2020 16:00 $ 199.97 9.13 1686.01 $426 38.03 $ 5.26 $ 217.35 S 133.93 0.54% 12 MSFT 92% Microsoft Corporation 9/30/2020 16:00 S 210.33 33.74 7567.65 $1,592 36,49 $ 5.76 $ 232.86 S 132.52 0.45% 90% 159% 13 PFE Pfizer Inc. 9/30/2020 16:02 S 36.70 21.38 5556.88 $204 14.59 $ 2.52 $ 40.97 S 27.88 0.38% 90% 1325 14 MRK Merck & Co., Inc 9/30/2020 16:02 $ 82.95 11.06 2529.24 $210 20.2 $ 4.11 $ 92.64 $ 55 25 0.44% 1278 15 MMM / 9/30/2020 16:04 $ 160.18 3.05 576.02 $92 18.16 $ 8.82 $ 182.55 $ 114.04 0.53% 889 140% 16 AAPL Apple Inc 9/30/2020 16:00 S 115.81 142.08 17337.34 $2,008 35.21 $ 3.29 $ 137,98 $ $3.15 0.82% 84% 218% 17 DOW Dow Inc 9/30/2020 16.00 S 47.05 4.66 741.12 $35 #N/A $ 12.65) $ 56.25 $ 21.95 0.63% 84% 214 18 KO Coca-Cola Co 9/30/2020 16:00 $ 49.37 15.72 4295,44 $212 23.22 $ 2.13 $ 60.13 $ 36.27 0.37% 82% 136% 19 DIS Walt Disney Co 9/30/2020 16:03 $ 124.08 13.54 1807.06 $224 WN/A $ 10,62 $ 153.41 $ 79.07 0.75% 81% 157% 20 65 Goldman Sachs Group Inc 9/30/2020 16:00 $ 200.97 3.07 344.00 $69 15.29 $13.15 $ 250.45 $ 130.85 0.99% 90% 154 21 CSCO Cisco Systems, Inc 9/30/2020 16:00 S 27.07 4233.43 $167 14.94 $ 2.64 $ 50.28 $ 32.40 0.64% 78% 1.22% 22 IBM IBM Common Stock 9/30/2020 16:00 S 121.67 3.26 890.58 $105 13.81 $ 8.81 $ 158.75 $ 90.56 0.37% % 77% 134 23 INTO 9/30/2020 16:00 Intel Corporation 51.78 27.63 4253 $220 43.63 9.53 $ 5.44 $ 69.29 $ 0.65% 75% 119% 244 MAX P American Express Company 9/30/2020 16:03 $ 100.25 5.06 805.16 $81 20.76 $ 4.83 $138.13 $ 67.00 0.63% 73% 150% Travelers Companies Inc 9/30/2020 16:00 $ 25 TRV 0.63% 109.19 1.6 $27 253.19 15.44 $ 7.01 $ 149.58 $ 76.99 141% $ 95.27 16.35 9/30/2020 16:00 S 26 PM 3047.6 JPMorgan Chase & Co. 0.54N $293 12.97 $ 7.42 $ 141.10 $ 76.91 68% % 125% 10.39 1867.32 9/30/2020 16:03 S 72.00 0.56% $134 WN/A $ (4.71) S 122.94 $ 51.60 Chevron Corporation 59 27 CVX 140% 35.92 856 53 6.67 0.77% 9/30/2020 16:00 $ 28 WBA $3144.05 $ 0.82 $ 64.50 $ 33.88 100 56% Walgreens Boots Alliance Inc 22.21 4228.23 34.33 73.12 S 30.11 DS3 $145 20.45 $ 1.68 $ 114% 29 XOM Exxon Mobil Corporation 9/30/2020 16:05 $ 0.SON 1527.66 $88 1814.57 $ 0.03 $ 158.44 $ 48.05 36% 7.7 120% 57.54 30 RTX Raytheon Technologies Corp 9/30/2020 16:00 $ #N/A 31 NKE #N/A 39.39 SON B C D 1 E Ticker - Company Name - Last Traded H M Shares Traded (mil) - Shares Out (mil) - Market Cap ($bil) - P/E - EPS 52-wk Hiwk to Column 12 - Most Active - X52-wk Hi-552-wk to - Columns 2 BABA Alibaba Group Holding Ltd - ADR 9/30/2020 16:00 S 293.98 3 PG 24.68 Procter & Gamble Co 21645.09 $6,363 9/30/2020 16:02 S 30.54 $ 9.63 S 299.00 $ 161.68 0.11% 138.99 8.73 96% 1825 4 MCD Mcdonald's Corp 2489.62 $346 28.02 $ 4.96 $ 141.70 S 94.34 9/30/2020 16:00 $ 9995 219.49 0.35% 3.03 147% 5 UNH United Health Group Inc 744.1 $163 34.8 $ 6.31 $ 226.72 $ 124.23 9/30/2020 16:00 $ 0.41 97% 177% 311.77 3.47 950.34 6 VZ Verizon Communications Inc. $296 0.36% 17.53 $17.78 $ 324.57 $ 187.72 9/30/2020 16:00 $ 96% 156% 59.49 16.35 4138.05 7 CAT $246 Caterpillar Inc 12.86 $ 4.62 $ 62.22 $ 48.84 0.40% 95% 9/30/2020 16:00 $ 127 149.15 3.64 541.51 BJNJ 581 20.01 $ 7.45 $ 156.25 S Johnson & Johnson 87.50 0.67% 95% 170 9/30/2020 16:00 $ 148.88 8.48 2632.82 $392 26.18 $ 5.59 $ 157.00 $ 109.16 9 HD 0.32% % Home Depot Inc 95% 136% 9/30/2020 16:00 S 277.71 4.78 1076.46 $299 25.44 $10.92 $ 292.95 $ 140.63 10 WMT Walmart Inc 0.44% 95% 197% 9/30/2020 16:00 $ 139.91 11.59 2833.75 $396 22.3 $ 6.27 $ 151.33 $ 102.00 92% 11 v 0.41% 137% Visa Inc 9/30/2020 16:00 $ 199.97 9.13 1686.01 $426 38.03 $ 5.26 $ 217.35 S 133.93 0.54% 12 MSFT 92% Microsoft Corporation 9/30/2020 16:00 S 210.33 33.74 7567.65 $1,592 36,49 $ 5.76 $ 232.86 S 132.52 0.45% 90% 159% 13 PFE Pfizer Inc. 9/30/2020 16:02 S 36.70 21.38 5556.88 $204 14.59 $ 2.52 $ 40.97 S 27.88 0.38% 90% 1325 14 MRK Merck & Co., Inc 9/30/2020 16:02 $ 82.95 11.06 2529.24 $210 20.2 $ 4.11 $ 92.64 $ 55 25 0.44% 1278 15 MMM / 9/30/2020 16:04 $ 160.18 3.05 576.02 $92 18.16 $ 8.82 $ 182.55 $ 114.04 0.53% 889 140% 16 AAPL Apple Inc 9/30/2020 16:00 S 115.81 142.08 17337.34 $2,008 35.21 $ 3.29 $ 137,98 $ $3.15 0.82% 84% 218% 17 DOW Dow Inc 9/30/2020 16.00 S 47.05 4.66 741.12 $35 #N/A $ 12.65) $ 56.25 $ 21.95 0.63% 84% 214 18 KO Coca-Cola Co 9/30/2020 16:00 $ 49.37 15.72 4295,44 $212 23.22 $ 2.13 $ 60.13 $ 36.27 0.37% 82% 136% 19 DIS Walt Disney Co 9/30/2020 16:03 $ 124.08 13.54 1807.06 $224 WN/A $ 10,62 $ 153.41 $ 79.07 0.75% 81% 157% 20 65 Goldman Sachs Group Inc 9/30/2020 16:00 $ 200.97 3.07 344.00 $69 15.29 $13.15 $ 250.45 $ 130.85 0.99% 90% 154 21 CSCO Cisco Systems, Inc 9/30/2020 16:00 S 27.07 4233.43 $167 14.94 $ 2.64 $ 50.28 $ 32.40 0.64% 78% 1.22% 22 IBM IBM Common Stock 9/30/2020 16:00 S 121.67 3.26 890.58 $105 13.81 $ 8.81 $ 158.75 $ 90.56 0.37% % 77% 134 23 INTO 9/30/2020 16:00 Intel Corporation 51.78 27.63 4253 $220 43.63 9.53 $ 5.44 $ 69.29 $ 0.65% 75% 119% 244 MAX P American Express Company 9/30/2020 16:03 $ 100.25 5.06 805.16 $81 20.76 $ 4.83 $138.13 $ 67.00 0.63% 73% 150% Travelers Companies Inc 9/30/2020 16:00 $ 25 TRV 0.63% 109.19 1.6 $27 253.19 15.44 $ 7.01 $ 149.58 $ 76.99 141% $ 95.27 16.35 9/30/2020 16:00 S 26 PM 3047.6 JPMorgan Chase & Co. 0.54N $293 12.97 $ 7.42 $ 141.10 $ 76.91 68% % 125% 10.39 1867.32 9/30/2020 16:03 S 72.00 0.56% $134 WN/A $ (4.71) S 122.94 $ 51.60 Chevron Corporation 59 27 CVX 140% 35.92 856 53 6.67 0.77% 9/30/2020 16:00 $ 28 WBA $3144.05 $ 0.82 $ 64.50 $ 33.88 100 56% Walgreens Boots Alliance Inc 22.21 4228.23 34.33 73.12 S 30.11 DS3 $145 20.45 $ 1.68 $ 114% 29 XOM Exxon Mobil Corporation 9/30/2020 16:05 $ 0.SON 1527.66 $88 1814.57 $ 0.03 $ 158.44 $ 48.05 36% 7.7 120% 57.54 30 RTX Raytheon Technologies Corp 9/30/2020 16:00 $ #N/A 31 NKE #N/A 39.39