Question

which of the following feature in ms excel lets you arrange data in ascending or descending order?

Answer 1

Answer:

To sort the numbers in ascending or descending order, we use the formulas “LARGE”, “SMALL” and “ROW” in Microsoft Excel. To sort in ascending order use the “SMALL” function along with the “ROW” function. And to sort in descending order use the “LARGE” function along with the “ROW” function.

Answer 2

Answer:

filter

apply filter option

then click on order accordingly