Matching
Match the following functions with their description.
Premises:
MODE.SNGL
MEDIAN
MODE.MULT
AVERAGE
MODE
Responses:
Returns the most frequently occurring value in a range
Returns the mean from a specified range of cells
Returns the number in the middle of a set of numbers
The legacy version
Used to return a vertical array,or list,of the most frequently occurring values in a range
Correct Answer:
Premises:
Responses:
MODE.SNGL
MEDIAN
MODE.MULT
AVERAGE
MODE
Premises:
MODE.SNGL
MEDIAN
MODE.MULT
AVERAGE
MODE
Responses:
Related Questions
Q67: Match the following categories with their description.
Q68: Optional arguments in a function are enclosed
Q69: _ refers to the structure and order
Q70: Which of the following is NOT a
Q71: _ is the keyboard shortcut to display
Q73: If the value in B4 = 40,what
Q74: Which of the following is NOT an
Q75: Instead of typing the $ symbol in
Q76: To return the number of cells in
Q77: Excel's RANDBETWEEN function returns a random number