Question
Which of the following formulas correctly calculates
the sum of values in cells A1 to A5 in Excel?Solution
=SUM(A1:A5)
In a class of 40 students, the average weight of the class is 65 kg, but when one of the students left from the school and 6 new ...
- The incomes of ‘X’, ‘Y’ and ‘Z’ are in the ratio 3:4:5, respectively and the average of their incomes is Rs. 12,000. If ‘X’, ‘Y’ and �...
The average weight of 15 oarsmen in a boat is increased by 1.6 kg when one of the crew, who weighs 42 kg, is replaced by a new man. Find the weight of t...
- The average of two numbers is 12 more than the smaller number among them. If the greater number is 150% more than the smaller number, then find the sum of ...
Average of 8 numbers is 70. If average of first four and last two numbers is 90 and 50, respectively then find the fifth number given that ratio of fift...
The average of a set of 's' numbers is 25. If 100 is added to the set, then the average of the set becomes 25.2. Find the value of '4 X (s - 9)'.
"The average age of all employees in a company is 23.5 years. The average age of male employees is 25.2 years, while the average ...
Average marks scored by each boy in a class were 85, whereas that by each girl were 95. If the number of boys is 50% more than the number of girls, then...
The average of the present age of 6 members of a family is 42 years. The present age of the youngest member is 12 years. Then what was the average age o...
The average score of a group of 50 students is 90. When the scores of 4 students—X, Y, Z, and W—are excluded, the average of the rest falls by 2. If...
