Question

arithmetic functions in ms office
and their uses with exampl​

Answer 1

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.