To find the average value of A1, A2, A3, which of the following is not a correct formula ?

A = Sum (A1 : A3)/3
B = (A1 : A3)/3
C = (A1-A2+A3)/3
D = Average (A1:A3)

Correct Answer: = Average (A1:A3)

A column - এর তিনটি সারি (raw) A1, A2 ও A3 এর গড়মান (Average Value) বের করার জন্য excel sheet - এর formula bar - এ যে formula টি লিখতে হবে তা হলো = Average (A1 : A3)
Bissoy MCQ
#তথ্য প্রযুক্তি #Bangladesh Bank #এক্সেল (MS Excel) #Bangladesh Bank - Assistant Director - 2015

Related Questions

Three maths classes: X, Y, and Z take an algebra test. The average score of class X is 83. The average score of class Y is 76. The average score of class Z is 85. The average score of class X and Y is 79 and the average score of class Y and Z is 81. What is the average score of the combined classes X, Y, and Z?
A 81
B 81.5
C 82
D 84.5
Three math classes , X, Y , and Z, take an algebra test. The average score in class X is 83. The average score in class Y is 76. The average score in class Z is 85. The average score of all students in classes X and Y together is 79. The average score of all student classes Y and Z together is 81. What is the average for all the three classes?
A 81
B 81.5
C 82
D 84.5
The average marks obtained by a group of 16 students was 20. One student left the group as a result of which the average of the remaining students rose to 21. But another student joined, as a result of which the average marks of the group dropped a bit and became 20.5. What was the average marks obtained by the student who left and the one who joined?
A 10
B 11
C 8
D 9
In a set of three numbers, the average of first two numbers is 2. The average of the last two numbers is 3, and the average of the first and the last numbers is 4. What is the average of three numbers ?
A 3
B 6
C 9
D 24
The average of eight numbers in 14. The average of six of these numbers 16. The average of the remaining two numbers is 16. The average of the remaining two numbers is-
A 4
B 8
C 16
D Data inadequate
In company X, the average salary of 10 of the employees is TK. 30,000 the average salary of 30 other employees is TK. 40,000 and the average salary of the remaining 20 employees TK. 60,000. What is the average salary of the 60 employees at the company ?
A TK. 40,000
B TK. 43,000
C TK. 45,000
D TK. 60,000
The average of six numbers is 3.95. The average of two of them is 3.4, while average of the other two is 3.85. What is the average of the remaining two numbers?
A 4.5
B 4.6
C 4.7
D 4.8
The average age of a group of 10 students was 20. The average age increased by 2 years when two new students joined the group. What is the average age of the group. What is the average age of the two new students who joined the group?
A 22 years
B 30 years
C 40 years
D 32 years
If x is the average (arithmetic mean) of m and 9, y is the average of 2m and 15, and z is the average of 3m and 18, What is the average of x, y and z in terms of m?
A m+6
B m+7
C 2m+14
D 3m+21
The captain of a cricket team of 11 members is 26 years old and the wicket keeper is 3 years older . If the ages of these two are excluded, the average , the average age of the remaining players is one year less than the average age of the whole team. what is the average age of the whole team?
A 23 years
B 24 years
C 25 years
D 26 years

Next steps