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
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
Software piracy is an example of computer prevalence crime
Indicate whether the statement is true or false.