Answer:
RANK.AVG
Explanation:
Required
Arrange data in descending order based on average
The feature to do this is to use the RANK.AVG() function.
By default, the function will return the ranks of the selected data in descending order (i.e. from highest to lowest); though, the sort order can be changed to ascending order.
The syntax is:
=RANK.AVG (number, ref, [order])
Where
number
The number to use as rank
ref
The cell range
order
0 represents descending order while 1 represents ascending order
Answer:
The Condition-controlled loop
Explanation: Because its called a Condition and it does not stop untill something happens thats why its called "condition".