Excel: Basic Sorting - Practical 1

 

 

The given data set is extracted from student mark sheet. Prepare the table in Excel and perform the listed sorting operations.



Perform the listed sorting operations on above data set.

1.      Arrange the table data sort by Last Name ascending order.

2.      Arrange the table data sort by Total largest to smallest.

3.      Arrange the table data first by Last Name, Then by First Name ascending order.

4.      Arrange the table data sort by Total largest to smallest and then by Maths largest to smallest.

Post a Comment

Previous Post Next Post