Dear experts, please help me solve Q1. Waiting for your positive feedback.

Q a)   The class teacher of class VI B of Alsan Public School wants to sort the list of students in the ascending order of bus number and ascending order of the name. The teacher has given this task to the class monitor Jayant. Can you help him to complete this task

Dear Student,

Ascending Order of Name:
 
Roll No. Name Bus No.
1 Aman Bhardwaj 6
2 Amit Singh 6
3 Gaurav Kumar 1
4 Hemant Arora 2
5 Jayant Jain 5
6 Kajal Singh 2
7 Nirmal Pandey 4
8 Seema Jain 4
9 Vidhi Sharma 3
10 Vijay Desai 3

Ascending Order of Bus Number:
 
Roll No. Name Bus No.
1 Gaurav Kumar 1
2 Hemant Arora 2
3 Kajal Singh 2
4 Vidhi Sharma 3
5 Vijay Desai 3
6 Nirmal Pandey 4
7 Seema Jain 4
8 Jayant Jain 5
9 Aman Bhardwaj 6
10 Amit Singh 6


Hope this information clears your doubts about the topic.

Keep asking!!

Regards

  • 0
Although not an expert, a student, In excel:- 1. Select the student name and bus route no. 2. Select the data tab. 3. Select sort as.. 4. On the sort as dialogue select ascending. 5. Done!!!
  • 0
What are you looking for?