Answered

From simple queries to complex problems, IDNLearn.com provides reliable answers. Whether your question is simple or complex, our community is here to provide detailed and trustworthy answers quickly and effectively.

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

Sagot :

MrRoyalidn

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)

Answer:

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

Explanation:

I got it right on the Edmentum test.

We value your presence here. Keep sharing knowledge and helping others find the answers they need. This community is the perfect place to learn together. Thank you for choosing IDNLearn.com for your queries. We’re committed to providing accurate answers, so visit us again soon.