Book1 - Excel (Product Activation Failed) ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in AD26 X fx T U Y z AB AC AD AE AF AG 4 A B E F H L M N. N P 1 DAY LSK LTD ZED LTC ABC LTI XYZ LTC EASTEF WESTLI SOUTHL NORTHLTD ####### 1468.36 6456.9 8067.32 15307.8 2151.73 2745.83 325.72 53.89 3 ####### 1481.14 6432.5 7870.52 15680.7 2207.16 2688.33 327.4 56.06 4 ####### 1549.38 67216 8019.22 16737.6 2351.44 2643.49 355.81 59.74 5 ####### 1526.75 6466.8 7861.51 16785.7 2187.97 2359.21 325.91 53.08 6 02/01/2021 1473.99 6303.3 7638.17 16569.1 2062.08 2194.34 303.02 46.62 7 7 1/31/2021 1455.27 6360.1 7584.14 17248.9 2180.25 2348.67 316.36 48.18 1/30/2021 1503.35 6607.9 8007.32 18138.4 2190.87 2139.28 303.26 47.37 9 1/29/2021 1530.62 6621.4 7883.04 17875.8 2243.03 2084.32 292.65 46.1 10 1/28/2021 1482.37 6449.2 7408.87 17400.4 2154.55 1999.17 276.41 41.4 11 1/27/2021 1420.86 6308 6917.03 17287.7 2102.78 1830.92 263.38 39.68 12 1/26/2021 1406.82 6171.5 6715.44 17604.1 2067.64 1740.97 253.08 37.42 13 1/25/2021 1438.24 6203.1 6789.11 17383.4 2070.64 1757.26 251.24 38.56 14 1/24/2021 1418.3 6220.8 6596.92 17225.8 2090.46 1805.52 252.9 37.74 15 1/23/2021 1400.63 6048.8 6309.19 16274.3 1967.02 1718.96 243.51 35.77 16 1/22/2021 1377.94 6129.2 6268.92 16399.4 1781.68 1582.63 226.86 33.98 17 1/21/2021 1335.85 5960.8 6004.33 16127.6 1637.27 1637.27 1534.61 217.26 31.4 18 1/20/2021 1303.82 5906.1 5859.57 16140.8 16140.8 1662.84 1431.26 214.39 31.08 19 1/19/2021 1276.66 5928.3 5681.97 15456.8 1701.58 1351.65 211.21 30.63 20 1/18/2021 1270.2 5833.4 5683.31 15505.2 1711.09 1310.26 209.67 29.56 21 1/17/2021 1270.09 5723.8 5692.86 15467.3 1653.72 1330 212.27 28.53 22 1/16/2021 1310.61 6023.1 6009.89 16906.2 1908.61 1464.41 234.08 32.75 23 1/15/2021 1294.87 5964.6 5970.08 17059.7 1800.58 1322.97 217.56 29.61 24 1/14/2021 1280.66 5791.5 5796.04 16205.4 1714.05 1230.66 216.89 30.16 25 1/13/2021 1280.08 5760.3 5674.15 16649.8 1793.97 1232.32 218.92 30.24 26 01/12/2021 1248.29 5618.8 5408.26 16111.4 1543.31 1162.64 200.47 25.32 27 01/11/2021 1249.48 5423.2 5193.4 14872.2 1554.67 1096.64 188.52 25.14 28 01/10/2021 1207.01 5317.3 4929.07 13606.5 1608.86 1066.22 175.27 23.21 29 01/09/2021 1228.81 5477.7 5044.12 13574.3 1694.83 1079.28 186.52 24.26 30 01/08/2021 1220.33 5296.9 4829.69 12413.6 1581.65 1050.09 171.79 20.99 31 01/07/2021 1234.18 5282.3 4886.5 11899.6 1507.59 1182.3 173.75 19.68 32 01/06/2021 1191.33 5113.2 4586.28 11584 1367.41 1122.38 163.53 18.55 33 01/05/2021 1191.5 4964 4460.63 11276.6 11276.6 1485.55 1485.55 1088.17 158.89 17.6 34 01/04/2021 1156.85 4801.7 4184.84 11008.9 1348.35 1348.35 1029.61 154.56 16.3 35 01/03/2021 1180.59 4894.4 4348.77 11669 1400.42 1080.17 159.97 16.54 36 01/02/2021 1203.6 4968.5 4350.49 11740.6 1558.62 1073.83 171.3 17.93 37 01/01/2021 1181.27 4852.3 4254.85 11387.6 1373.79 1045.44 158.61 15.85 38 39 40 INSTURI READ CAREFULLY. ALL CALCULATIONS MUST BE DONE IN EXCEL USING EXCEL APPROPRIATE FORMULAS. 41 Q1 DAT/YOU ARE PRESENTED WITHEIGHT (8) STOCKS AND THEIR PRICES FROM 1ST JAN 2021 TO 5TH FEB 2021 42 ALL STOCKS BELONG TO THE Z STOCK EXCHANGE 43 ON 21ST JAN STOCK ZEDLTD HAS A 2 FOR 1STOCK SPLIT AFTER THE CLOSE OF DAY 44 ON 10TH JAN STOCK WEST UTD HAS A 3 FOR 1STOCK SPLIT AFTER THE CLOSE OF DAY 45 QUESTI CALCULATE THE DAILY INDEX AVERAGES FOR THE Z ALL SHARE INDEX (ZASI). ASSUME THE BASE DATE IS 1ST JAN 2021AND BASE VALUE OF 100 46 [] Sheet1 + READY O --+ + 63% Book1 - Excel (Product Activation Failed) ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in AD26 X fx T U Y z AB AC AD AE AF AG 4 A B E F H L M N. N P 1 DAY LSK LTD ZED LTC ABC LTI XYZ LTC EASTEF WESTLI SOUTHL NORTHLTD ####### 1468.36 6456.9 8067.32 15307.8 2151.73 2745.83 325.72 53.89 3 ####### 1481.14 6432.5 7870.52 15680.7 2207.16 2688.33 327.4 56.06 4 ####### 1549.38 67216 8019.22 16737.6 2351.44 2643.49 355.81 59.74 5 ####### 1526.75 6466.8 7861.51 16785.7 2187.97 2359.21 325.91 53.08 6 02/01/2021 1473.99 6303.3 7638.17 16569.1 2062.08 2194.34 303.02 46.62 7 7 1/31/2021 1455.27 6360.1 7584.14 17248.9 2180.25 2348.67 316.36 48.18 1/30/2021 1503.35 6607.9 8007.32 18138.4 2190.87 2139.28 303.26 47.37 9 1/29/2021 1530.62 6621.4 7883.04 17875.8 2243.03 2084.32 292.65 46.1 10 1/28/2021 1482.37 6449.2 7408.87 17400.4 2154.55 1999.17 276.41 41.4 11 1/27/2021 1420.86 6308 6917.03 17287.7 2102.78 1830.92 263.38 39.68 12 1/26/2021 1406.82 6171.5 6715.44 17604.1 2067.64 1740.97 253.08 37.42 13 1/25/2021 1438.24 6203.1 6789.11 17383.4 2070.64 1757.26 251.24 38.56 14 1/24/2021 1418.3 6220.8 6596.92 17225.8 2090.46 1805.52 252.9 37.74 15 1/23/2021 1400.63 6048.8 6309.19 16274.3 1967.02 1718.96 243.51 35.77 16 1/22/2021 1377.94 6129.2 6268.92 16399.4 1781.68 1582.63 226.86 33.98 17 1/21/2021 1335.85 5960.8 6004.33 16127.6 1637.27 1637.27 1534.61 217.26 31.4 18 1/20/2021 1303.82 5906.1 5859.57 16140.8 16140.8 1662.84 1431.26 214.39 31.08 19 1/19/2021 1276.66 5928.3 5681.97 15456.8 1701.58 1351.65 211.21 30.63 20 1/18/2021 1270.2 5833.4 5683.31 15505.2 1711.09 1310.26 209.67 29.56 21 1/17/2021 1270.09 5723.8 5692.86 15467.3 1653.72 1330 212.27 28.53 22 1/16/2021 1310.61 6023.1 6009.89 16906.2 1908.61 1464.41 234.08 32.75 23 1/15/2021 1294.87 5964.6 5970.08 17059.7 1800.58 1322.97 217.56 29.61 24 1/14/2021 1280.66 5791.5 5796.04 16205.4 1714.05 1230.66 216.89 30.16 25 1/13/2021 1280.08 5760.3 5674.15 16649.8 1793.97 1232.32 218.92 30.24 26 01/12/2021 1248.29 5618.8 5408.26 16111.4 1543.31 1162.64 200.47 25.32 27 01/11/2021 1249.48 5423.2 5193.4 14872.2 1554.67 1096.64 188.52 25.14 28 01/10/2021 1207.01 5317.3 4929.07 13606.5 1608.86 1066.22 175.27 23.21 29 01/09/2021 1228.81 5477.7 5044.12 13574.3 1694.83 1079.28 186.52 24.26 30 01/08/2021 1220.33 5296.9 4829.69 12413.6 1581.65 1050.09 171.79 20.99 31 01/07/2021 1234.18 5282.3 4886.5 11899.6 1507.59 1182.3 173.75 19.68 32 01/06/2021 1191.33 5113.2 4586.28 11584 1367.41 1122.38 163.53 18.55 33 01/05/2021 1191.5 4964 4460.63 11276.6 11276.6 1485.55 1485.55 1088.17 158.89 17.6 34 01/04/2021 1156.85 4801.7 4184.84 11008.9 1348.35 1348.35 1029.61 154.56 16.3 35 01/03/2021 1180.59 4894.4 4348.77 11669 1400.42 1080.17 159.97 16.54 36 01/02/2021 1203.6 4968.5 4350.49 11740.6 1558.62 1073.83 171.3 17.93 37 01/01/2021 1181.27 4852.3 4254.85 11387.6 1373.79 1045.44 158.61 15.85 38 39 40 INSTURI READ CAREFULLY. ALL CALCULATIONS MUST BE DONE IN EXCEL USING EXCEL APPROPRIATE FORMULAS. 41 Q1 DAT/YOU ARE PRESENTED WITHEIGHT (8) STOCKS AND THEIR PRICES FROM 1ST JAN 2021 TO 5TH FEB 2021 42 ALL STOCKS BELONG TO THE Z STOCK EXCHANGE 43 ON 21ST JAN STOCK ZEDLTD HAS A 2 FOR 1STOCK SPLIT AFTER THE CLOSE OF DAY 44 ON 10TH JAN STOCK WEST UTD HAS A 3 FOR 1STOCK SPLIT AFTER THE CLOSE OF DAY 45 QUESTI CALCULATE THE DAILY INDEX AVERAGES FOR THE Z ALL SHARE INDEX (ZASI). ASSUME THE BASE DATE IS 1ST JAN 2021AND BASE VALUE OF 100 46 [] Sheet1 + READY O --+ + 63%