Excel Functions Flashcard

Front

To find smallest number from a given cell range (e.g., A1:D2)

Back

MIN

Front

To find largest number from a given cell range (e.g., A1:D2)

Back

MAX

Front

To find total amount/add all the numbers in a given cell range (e.g., A1:D2)

Back

SUM

Front

To find average from a given cell range (e.g., A1:D2)

Back

AVERAGE

Front

To choose the cell that repeats the most number of times in a given cell range (e.g., A1:D2)

Back

MODE.SNGL

Front

To show the number in the middle after arranging the given cell range from smallest to largest

Back

MEDIAN

Front

To return a random number between the numbers you specify

Back

RANDBETWEEN

Front

To round a number to the specific no of digits

Back

ROUND

Front

TO ROUND UP A NUMBER AWAY FROM ZERO.

Back

ROUNDUP

Front

TO ROUND down A NUMBER towards ZERO.

Back

ROUNDDOWN