8. Please download the file final.xlsx and refer to Worksheet B. What is the sum of the first digits of all numbers listed in column A? 34 74 112 114 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 sb 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.104678 2892.54655 4049.56517 5669.391238 7937.147733 11112.00683 15556.80956 21779.53338 30491.34673 42687.88542 59763.03959 83668.25543 117135.5576 163989.7806 229585.6929 321419.97 449987.9581 629983.1413 881976.3978 1234766.957 1728673.74 2420143.236 3388200.53 4743480.742 6640873.038 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 1 2 3 4 5 7 9 10 11 12 13 14 15 16 17 18 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 44 Transaction number 23 47 76 6 11 80 33 37 29 50 58 67 85 4 25 95 55 57 35 34 13 96 53 70 78 100 20 46 30 89 72 2 87 17 69 19 54 43 83 12 28 45 26 Worksheet A Quantity 149 $ 149 $ 147 S 1465 145 $ 144 S 1425 1405 139 S 139 $ 138 S 138 5 136 $ 135 S 135 S 135 $ 134 $ 132 $ 130 $ 129 $ 128 S 126 $ 125 122 S 120 $ 120 118$ 118 $ 114 S 113 S 112 $ 110 $ 106 S 104 $ 101 $ 100 S 100 $ 98 5 98 5 97 S 975 97 $ 95 Worksheet B Unit price 19.08 S 34.19 $ 39.515 26.505 31.59 $ 25.35 5 37.665 20.60 $ 35.56 5 23.63 5 27.555 20.53 $ 31.82 5 36.52 S 32.38 $ 39.62 $ 32.12 s 17.44 S 39.23 $ 38.065 35.99 $ 35.36 $ 28.58 $ 33.43 5 22.40 $ 33.78 $ 30.81 S 29.14 S 38.92 5 32.29 $ 19.82 $ 22.68 $ 28.49 $ 22.55 $ 34.04 $ 20.045 32.98 $ 28.63 S 38.765 20.70 $ 26.87 $ 24.48 $ 3421S + Total 2,842.92 5,094.31 5,807.97 3,869.00 4,580.55 3,650.40 5,347.72 2,884.00 4,942.84 3,284.57 3,801.90 2,833.14 4,327.52 4,930,20 4,371.30 5,348.70 4,304.08 2,302.08 5,099.90 4,909.74 4,606.72 4,455,36 3.572.50 4,078.46 2,688.00 4,053.60 3,635.58 3,438.52 4,436.88 3,648.73 2,219.84 2.494.80 3,019.94 2,345.20 3,438.04 2.004.00 3,298.00 2,805.74 3,798.48 2,007.90 2,606.39 2,374.56 3.249.95 Ready 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 45 26 65 91 8 14 90 48 49 98 44 97 16 31 7 32 3 10 1 36 92 66 73 88 9 41 51 B 97 s 95 $ 93 $ 93 S 92 $ 91 S 89 $ 88 $ 88 $ 87 $ BS $ 85 $ 84 $ 83 S 81 $ 81 $ 79 $ 75 $ 73 $ 71 $ 71 $ 70 $ 70 $ 70 $ 69 $ 67 S 66 $ 66 $ 66 $ 64 $ 63 $ 62 $ 60 $ 60 $ 60 $ 58 $ 58 $ 55 $ 55 S 54 S 54 S 51 S 48 $ 48 $ Worksheet B C 24.48 ES 34.21 $ 25.10 S 33.51 $ 29.92 $ 38.48 $ 20.62 $ 22.96 $ 17.40 S 25.64 $ 32.39 $ 33.44 $ 31.21 $ 39.77 $ 38.76 $ 25.48 $ 22.84 S 20.35 $ 32.41 $ 35.38 $ 18.95 $ 39.56 S 19.08 $ 24.42 $ 20.93 $ 32.32 $ 24.81 S 34.73 $ 39.72 $ 29.06 $ 33.95 $ 38.24 $ 36.79 $ 29.31 $ 19.46 $ 34.82 $ 29.08 $ 24.60 $ 35.06 $ 18.31 S 31.94 $ 21.65 S 28.48 $ 31.35 $ + 2,374556 3,249.95 2,334.30 3,116.43 2,752.64 3,501.68 1,835.18 2,020.48 1.531.20 2,230.68 2,753.15 2,842.40 2,621.64 3,300.91 3,139.56 2,063.88 1,804.36 1,526.25 2,365.93 2,511.98 1,345.45 2,769.20 1,335.60 1,709.40 1,444.17 2,165.44 1,637.46 2,292.18 2,621.52 1,859.84 2,138.85 2,370.88 2,207.40 1,758.60 1,167.60 2,019.56 1,686.64 1,353,00 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504,80 64 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 68 Worksheet A Ready A1 fx Transaction number B E F EBBARRERESERS: 2:12:28.22 41 51 64 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 68 82 52 75 15 39 38 62 71 24 60 42 74 63 93 94 67 66 S 66 S 66 S 64 S 63 $ 62 $ 60 S 60 $ 60 $ 58 $ 58 $ 55 $ 55 $ 54 $ 54 $ 51 $ 48 S 48 S 46 $ 44 $ 44 $ 43 $ 43 $ 42 $ 39 38 $ C 5252 5 24.81 $ 34.73 $ 39.72 $ 29.06 S 33.95 $ 38.24 $ 36.79 $ 29.31 $ 19.46 $ 34.82 $ 29.08 $ 24.60 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28,48 $ 31.35 $ 17.37 S 37.52 $ 17.24 $ 17.36 $ 32.32 $ 39.16 $ 32.21 $ 32.32 $ 29.68 $ 22.93 $ 32.47 $ 26.42 $ 37.43 S 23.14 $ 26.29 $ D 20 1,637.46 2,292.18 2,621.52 1,859.84 2,138.85 2,370.88 2,207,40 1,758,60 1,167.60 2,019.56 1,686.64 1,353.00 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 799.02 1,650.88 758.56 746.48 1,389.76 1,644.72 1,256.19 1,228.16 1,098.16 848.41 1,071.51 792.60 973.18 601.64 657.25 + 37 S 37 $ 33 $ 30 $ 26 $ 26 $ 25 $ Worksheet A Worksheet B + Ready
