Matching
Match the math and statistical functions to their descriptions:
Premises:
=ROUND(number,num_digits)
=FREQUENCY(data_array,bins_array)
=MODE.SNGL(number1,[number2],... )
=INT(number)
=ABS(number)
Responses:
counts how often a value appears in a given range
displays the absolute value of a number
rounds a value number down to the whole number
displays the most frequently occurring value in a list
numbers of 5 and greater go up and less than 5 go down
Correct Answer:
Premises:
Responses:
=ROUND(number,num_digits)
=FREQUENCY(data_array,bins_array)
=MODE.SNGL(number1,[number2],... )
=INT(number)
=ABS(number)
Premises:
=ROUND(number,num_digits)
=FREQUENCY(data_array,bins_array)
=MODE.SNGL(number1,[number2],... )
=INT(number)
=ABS(number)
Responses:
Related Questions
Q14: Because the SUM function is a rarely
Q24: The IF function only evaluates a condition
Q26: The _ function category performs calculations such
Q27: Match the function categories to their descriptions:
Q28: While lookup tables are typically designed vertically,they
Q30: The IF function in Excel 2013 has
Q31: What is the F4 key used for
Q33: Formula _ displays a list of functions
Q34: How are an input area on a
Q80: A mixed cell reference<br>A) occurs when a