Multiple Choice
The RANK.EQ function returns ________.
A) the rank of a value within a dataset, giving an average ranking to tied values
B) the rank of a value within a dataset, giving the highest ranking possible to ties
C) the rank of a value within a dataset, throwing out ties
D) the rank of a value within a dataset, giving the same ranking to tied values
Correct Answer:
Verified
Correct Answer:
Verified
Q64: The _ function returns the length of
Q65: In SUMIFS, AVERAGEIFS and COUNTIFS functions, you
Q66: The CORREL function would be useful to
Q67: Match each of the following terms to
Q68: Excel 2016 has NO new functions in
Q70: Relative Standing measures _.<br>A)the median of a
Q71: This is the top three lines in
Q72: This formula will successfully count all green
Q73: The _ is an add-in program that
Q74: Which function would you use to test