Calculate a function in descending order with an absolute reference?

I appreciate that you're not asking us to do the whole assignment, however that's not much comfort for those of us that actually studied our way through college; and again, is potentially very unfair on your classmates.

Anyhow:

Originally Posted by apaya

In cell E6, insert a function that will rank the value in D6....

Have you had a look at any of the RANK functions?

Originally Posted by apaya

Enter the range as an absolute reference.

Do you know what absolute referencing is?