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.