Question

Match the spreadsheet functions to their operations.

ROUND
COUNT
MIN
MAX

-tells you how many numbers are present in a set of numbers or cell range
-trims numbers with trailing decimal digits to display only a specified number of those decimals
-tells you the lowest value in a set of numbers
-tells you the highest value in a set of numbers

Answer 1

Tells you how many numbers are present in a set of numbers or cell range - COUNT

trims numbers with trailing decimal digits to display only a specified number of those decimals - ROUND

Tells you the lowest value in a set of numbers - MIN

Tells you the highest value in a set of numbers - MAX

Step-by-step explanation:

I got it right on the Edmentum test.

Answer 2

The match is as follows:

ROUND: -trims numbers with trailing decimal digits to display only a specified number of those decimals

COUNT: -tells you how many numbers are present in a set of numbers or cell range

MIN: -tells you the lowest value in a set of numbers

MAX: -tells you the highest value in a set of numbers

Step-by-step explanation:

The answers are self-explanatory. However, the usage of each function is as follows:

(a) ROUND

= ROUND(cell)

e.g, = ROUND(A1) to round up A1

(b) COUNT

= COUNT(cell range)

e.g. = COUNT(A1,A5)

(c) MIN

= MIN(cell range)

e.g. = MIN(A1,A5)

(d) MAX

= MAX(cell range)

e.g. = MAX(A1,A5)