Answer:
The answer to this question is given below in the explanation section
Explanation:
There are different mathematical functions that can be used in the spreadsheet for performing some required calculations on data such as taking the average of numbers, adding numbers, multiplying the numbers.
But most commonly used three mathematical functions in the spreadsheet is given below:
1. AVERAGE(): The average function is used to find the average of a given number of cells.
Syntax of Average() function: average(number1, number2,.....).
2. SUM(): The sum function is used to add all the values within a range of cells.
Syntax: of sum() function: sum(cell address1: cell address2)
3.COUNT(): Count () function is used to count the number of data.
Syntax of Count() function: count(cell address1: cell address2)
