The .EXC descriptor in PERCENTRANK.EXC stands for:
A)inclusive.
B)increment.
C)expert.
D)exclusive.

Question

Quizplus · Accepted Answer

The .EXC descriptor in PERCENTRANK.EXC stands for exclusive, which means that the smallest value in the range has a rank of 0% and the largest value has a rank of 100% but excludes the percentile rank of the value itself. This differs from the PERCENTRANK.INC function, which is inclusive and includes the percentile rank of the value itself.

The .EXC Descriptor in PERCENTRANK.EXC Stands For