Question

please tell me correct answer


What is the purpose of a) power() b) product() c) mod() d) sqrt() functions in MS Excel? Explain each function with an example​

Answer 1

Explanation:

The purpose of power function is to return the result of a number raised to power. Eg- Y=X^N where Y, X and N are constants.

The purpose of the excel mod function is to carry out the mathematical operation of division. It returns the remainder of 2 numbers. Eg- MOD(7,5=1).

The purpose of product function is to carry out the mathematical operation of multiplication. It finds the product of 2 numbers given in a certain cell Eg- =PRODUCT(A1,A2)

The purpose of sqrt function is to give the sqrt of a positive no. Eg- 4 * 4 = 16