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 123… 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.
