Bunuel
If a clerk enters a total of 24 amounts on an MS-Office Excel sheet that has six rows and four columns, what is the average of all the 24 amounts entered on the Excel sheet?
(1) The sum of averages of the amounts in six rows is 720.
(2) The sum of averages of the amounts in four columns is 480.
Question: SUm of all 24 entries = ?Statement 1: The sum of averages of the amounts in six rows is 720.i.e. If averages of rows were a, b, c, d, e, f respectively then a+b+c+d+e+f = 720
Also, Sum of first row = 4*a (as the row is divided in four columns)
Also, Sum of Second row = 4*b
and so on..
i.e. Sum of all 24 entries = 4*(a+b+c+d+e+f) = 4*720 = 2880
SUFFICIENT
Statement 2: The sum of averages of the amounts in four columns is 480.Let, Averages of columns are p, q, r and s
now, given as p+q+r+s = 480
i.e. Sum of 6 entries of first column = 6*p
i.e. Sum of 6 entries of Second column = 6*q
and so on...
i.e. Sum of all 24 entries = 6*(p+q+r+s) = 6*480 = 2880
SUFFICIENT
Answer: Option D