Explanation
Excel provides a large collection of mathematical functions that make calculations faster and more accurate.
Important Functions
|
Function |
Purpose |
|
SUM |
Adds numbers |
|
PRODUCT |
Multiplies numbers |
|
ROUND |
Rounds a number |
|
ROUNDUP |
Rounds up |
|
ROUNDDOWN |
Rounds down |
|
INT |
Returns integer portion |
|
TRUNC |
Removes decimal portion |
|
MOD |
Returns remainder |
|
ABS |
Returns absolute value |
|
POWER |
Calculates power |
|
SQRT |
Calculates square root |
|
CEILING |
Rounds up to a multiple |
|
FLOOR |
Rounds down to a multiple |
|
RAND |
Generates random decimal |
|
RANDBETWEEN |
Generates random whole number |
|
SUMPRODUCT |
Multiplies corresponding values and adds results |
|
PI |
Returns π |
|
SIN, COS, TAN |
Trigonometric calculations |
Practice
Create a worksheet containing different numbers and test at least 10 Math & Trigonometry functions.