1.

Explain any five mathematical functions in MS excel with example.

Answer»

1.  abs() function in excel returns the absolute value of a number. The absolute value of a number is the number without its sign.

For example, Abs(-25)

output: 25

2. Fact() function returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number.

For example, fact(5)

output: 120

3. The mod() function returns the remainder after number is divided by divisor. The result has the same sign as divisor. MOD(number, divisor)

For example, Mod(5,2)

output: 1

4. The power () function returns the result of a number raised to a power. POWER(number, power)

For example, power(5,2)

output: 25

The sum() function adds all the numbers that is specified in the brackets.

For example, SUM(A1 : A5) adds all the numbers that are contained in cells A1 through A5. For another example, SUM(A1, A3, A5) adds the numbers that are contained in cells A1, A3, and A5.


Discussion

No Comment Found

Related InterviewSolutions