Matching
Match the following functions to their definition.
Premises:
COUNTA
AVERAGE
COUNT
MEDIAN
MODE.SNGL
Responses:
Returns the mean of a set of numbers
Counts the number of cells in a range that contain numbers
Returns the value the occurs most often in a range
Counts the number of cells in a range that are not empty
Returns the number in the middle of a set of numbers
Correct Answer:
Premises:
Responses:
COUNTA
AVERAGE
COUNT
MEDIAN
MODE.SNGL
Premises:
COUNTA
AVERAGE
COUNT
MEDIAN
MODE.SNGL
Responses:
Related Questions
Q7: When cell D4 containing the formula =$A4-B$5
Q10: If you wanted to determine how many
Q11: Given the following information:<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3001/.jpg" alt="Given
Q14: When cell D3 containing the formula =$B$5^$C$6
Q15: Function arguments are enclosed in a pair
Q17: Match the following terms to their definition.
Q46: The result of =LEFT("Washington",4)is Wash.
Q53: The _ function returns the number of
Q80: An absolute cell reference is denoted by
Q90: =$B$2 - C5 is an example of