Please refer to Worksheet B in the file final.xlsx. The sum of the first digits

Question

Please refer to Worksheet B in the file final.xlsx. The sum of the first digits of all numbers listed in column A is ____. (For example, the first number has a first digit of 1.)

Enter just the number; e.g., 218.

---------(please copy the numbers below to excel)

Column A

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

Explanation / Answer

formula for B1 is -> =INT(A1/POWER(10,LEN(INT(A1))-1))

if we copy the the values to A column and use above formula we can extarct the first digits of all numbers to column B then we can get the sum of cloumn B

108

so answer is 108

100 1 140 1 196 1 274.4 2 384.16 3 537.824 5 752.9536 7 1054.13504 1 1475.789056 1 2066.104678 2 2892.54655 2 4049.56517 4 5669.391238 5 7937.147733 7 11112.00683 1 15556.80956 1 21779.53338 2 30491.34673 3 42687.88542 4 59763.03959 5 83668.25543 8 117135.5576 1 163989.7806 1 229585.6929 2 321419.97 3 449987.9581 4 629983.1413 6 881976.3978 8 1234766.957 1 1728673.74 1 2420143.236 2 3388200.53 3 4743480.742 4 6640873.038 6

108

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.