Question

calculating the average of marks entered in cell e5 f5 g5 h5 and 15

Answer 1

The formula is:- =AVERAGE(e5:i5)

For calculations of marks entered in cell e5 , f5, g5, h5 and i5 you have to enter a formula in the cell of spreadsheet.

• The formula is:- =AVERAGE(e5:i5)

• then press enter
• you will see the average marks will be calculated

• It is mandatory to put = sign before entering any type of formulas in the cell of excel spreadsheet

like, Sum:- =SUM( range of data) press enter

So the answer is =AVERAGE(e5:i5)