What does the MEDIAN function do?
A) Identifies the lowest value in a range
B) Identifies the midpoint value in a set of values
C) Identifies the highest value in a range
D) Tallies the number of cells in a range that contain values
Correct Answer:
Verified
Q1: Which of the following is a new
Q3: Argument names that display in _ are
Q6: Syntax:
A)displays a list of functions and defined
Q7: The COUNTBLANK function:
A)tallies the number of blank
Q8: For a straightforward,basic mathematical expression,it is best
Q9: The ellipsis in function syntax indicates that:
A)you
Q10: What does a function ScreenTip do?
A)Automatically inserts
Q11: A relative cell reference:
A)indicates a cell's specific
Q17: The SUM function
A) identifies the midpoint value
Q20: A mixed cell reference
A) occurs when a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents