Match the math and statistical functions to their descriptions:

I. =ROUND(number,nun_digits) A. Returns the average of the
internal values in a range by
excluding the outliers
II. =SUMPRODUCT(array1,[array2],[array3],...) B. Finds the result of multiplying
the values in one range by the
related values in another column
and then adding those products
III. =TRIMMEAN(array1,percent) C. Rounds a value to a specific
number of digits
IV. =TRUNC(number,[num_digits]) D. Displays the absolute value
of a number
V. =ABS(number) E. Returns the integer equivalent
of a number by removing the
decimal or fractional portion

C, B, A, E, D

Computer Science & Information Technology

You might also like to view...

A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________

A) separate B) embedded C) layered D) selected

Computer Science & Information Technology

Software piracy is an example of computer prevalence crime

Indicate whether the statement is true or false.

Computer Science & Information Technology