A practice score of 48 has no obvious meaning on its own. Put it beside the scores it is being compared with and calculate its rank on that reference scale.
Use the known score as the lookup value
Put 24, 32, 41, 48 and 61 in A2:A6, and 48 in C2. In D2, enter:
=PERCENTRANK.INC(A2:A6,C2)The result is 0.75. With five distinct scores there are four gaps between the endpoints, and 48 is three gaps up from the low end.

Illustrated rank. Divide the three intervals below by four total intervals.
Check the endpoints and the reference range
Try 24 and 61. Expect 0% and 100% after percentage formatting. Label the output Inclusive percentile rank. A value between scores can receive an interpolated rank, so avoid interpreting it as a count of people without checking how the reference set is distributed.

Illustrated endpoints. Keep the reference range attached to the result.



