When you have data and you want to increase productivity with excel please use function instead of formula, let’s
take example when you want to Grand Total of 10 students marks you would have
to use following formula.
=B2+B3+B4+B5+B6+B7+B8+B9+B10+B11
With the use of Function
the above formula is
=SUM (B2:B11)