The QUARTILE.EXC functions returns values in the range:
________.
A)0 to 4
B)1 to 4
C)0 to 3
D)1 to 3

Question

Quizplus · Accepted Answer

The QUARTILE.EXC function returns values in the range 0 to 3. This function is used to calculate quartiles where the first quartile (Q1) is returned from the range 0 to 1, the second quartile (Q2 or the median) is returned from the range 1 to 2, and the third quartile (Q3) is returned from the range 2 to 3.

The QUARTILE.EXC Functions Returns Values in the Range