Question

5. Cell A1, A2, A3 and A4 contains marks in five subject what is the correct formula to calculate average
marks.
(a) =A1+A2+A3+A4/4 (b) =(A1+A2+A3+A4)4 (c) =average(A1:A4) (d) avg(A1:A4)

Answer 1

Answer:-

Cell A1 to A4 contains marks of 4 subjects.

To calculate the average of marks, write this formula,

=AVERAGE(A1:A4)

The AVERAGE() function is used to calculate average.

You can also write this,

=(A1+A2+A3+A4)/4

Or,

=SUM(A1:A4)/4