Final answer:
The function in Excel that is used to calculate a percentile is PERCENTILE. The PERCENTILE.INC, PERCENTILE.EXC, and PERCENTILE.RANK functions are also available for different purposes.
Step-by-step explanation:
The function in Excel that is used to calculate a percentile is PERCENTILE. The PERCENTILE.INC function can also be used to calculate percentiles, but it includes the actual values in the calculation. The PERCENTILE.EXC function is similar to the PERCENTILE function, but it excludes the actual values in the calculation. The PERCENTILE.RANK function is used to calculate the percentile rank of a value in a data set.