Question

Varun is maintaining the marksheet of his class in MS-Excel the teacher has asked Varun to find the maximum and minimum marks obtained in the class which feature of should Varun used in order to accomplish the task​

Answer 1

Answer:

As shown in the above example, to rank numbers from highest to lowest, you use one of the Excel Rank formulas with the order argument set to 0 or omitted (default). To have number ranked against other numbers sorted in ascending order, put 1 or any other non-zero value in the optional third argument.