The MEDIAN function
A) displays 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
Q13: A formula in Excel must begin with
A)
Q14: An absolute cell reference
A) causes a potential
Q15: Semi-selection or pointing
A) indicates a cells relative
Q16: A relative cell reference
A) indicates a cell's
Q17: The SUM function
A) identifies the midpoint value
Q19: For a basic mathematical expression it is
Q20: A mixed cell reference
A) occurs when a
Q21: The PV is
A) a set of range
Q22: The COUNTA function
A) evaluates a condition and
Q23: A nested function
A) contains data for the
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