Question

Match the spreadsheet functions to their operations.

Answer 1

Answer:

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

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)