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...
By default, what appears in a menu widget that is dragged onto a page?
What will be an ideal response?
Kernel buffers are stored
A. in computer memory B. on hard disks
Internal styles are the ones you will probably use in a work environment.
Answer the following statement true (T) or false (F)
In which of the following areas are you least likely to find examples of automation?
A. Cleanup efforts in a toxic environment B. Technical writing C. Microprocessor manufacturing D. Retail store checkout lines