MATHEMATICAL FUNCTION  1. SUM: Sum function is used to calculate a simple total for a range of numeric cells. SYNTAX:  =SUM (number1, [number2], …) EXAMPLE: Add…