Question

Explain the uses of any two inbuilt mathematical functions in Excel.

Answer 1

Answer:

MAX() AND MIN() ARE TWO MATHEMATICAL FUNCTIONS IN EXCEL

Answer 2

Explanation:

A collection of pre written formulas can be defined as functions. These functions are special programs which accept the data and return a value after processing the data.

Two inbuilt mathematical functions in Excel are explained below.

SUM(): This SUM function is used for calculating the summation of numbers passed as arguments. The syntax is =SUM (num1, num2,…).

Average(): Here, the Average function is used for calculating the average of the numbers passed as arguments. The syntax is =Average(num1, num2, …).