MICROSOFT EXCEL FORMULA Basic Maths Functions Function Formula Example To add up the total =SUM(cell range ) =SUM(B2:B9) To add…