Please download the file final.xlsx and refer to Worksheet B. The sum of the sec

Question

Please download the file final.xlsx and refer to Worksheet B. The sum of the second digits of all numbers listed in column A is ___. (For example, the second number listed has a second digit of 4.)

100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.78906 2066.10468 2892.54655 4049.56517 5669.39124 7937.14773 11112.0068 15556.8096 21779.5334 30491.3467 42687.8854 59763.0396 83668.2554 117135.558 163989.781 229585.693 321419.97 449987.958 629983.141 881976.398 1234766.96 1728673.74 2420143.24 3388200.53 4743480.74 6640873.04

Explanation / Answer

Answer : worksheet B is not given, what is that may be. But the sum of second digits is :

It comes out to be : 138

To do this in excel :

First apply Left function to select two digits from the left for a number in each cell, then apply right function over it to select right one digit(and that will be second digit of the number). Now apply SUM as required.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---