Calculate a function in descending order with an absolute reference?

I have attached the file of the assignment I've been working on for three hours and I still can't seem to get these formulas. Can anyone help me?

In cell E6, insert a function that will rank the value in D6 based on the occupancy rates of all five apartment complexes, in descending order. Enter the range as an absolute reference. Copy the function down through E10.

In cell F6, insert a function that will sum the potential rent (i.e., the total rent if all units are occupied) for the apartment complex in A6. Copy the function down through F10.



Also if you have time can you help me with these two questions as well?

On the Database worksheet, perform an advanced filter on the list in the range A11:H24, using the criteria range A2:H4. Filter the data in place.

On the Loan worksheet, in cell E5, insert a PMT function, using the values in E2:E4 for the arguments.




This is the document: Exploring_e07_Grader_EOC.xlsx

This is my first time on this forum so please forgive me if I posted anything wrong. I really appreciate anyone's response.