Question

Spreadsheet feature that can be used to arrange data from highest to lowest based on average​

Answer 1

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 $\to$ The number to use as rank

ref $\to$ The cell range

order $\to$ 0 represents descending order while 1 represents ascending order