Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
he image shown below, consider the ssible to sort this data so that the Ave er and then the Name column is sor sults shown in the image below

he image shown below, consider the ssible to sort this data so that the Ave er and then the Name column is sor sults shown in the image below

icon
Related questions
Question

please answer my simple excel question accurately 

In the image shown below, consider the data in the cell range B5:E25. It is possible to sort this data so that the Average column is sorted in descending order and then the Name column is sorted in alphabetical order to produce the results shown in the image below. O Name 6 Banies Benjamin Deperstaff 9 Blogs 10 Boyd 11 Brownlee 12 Eldred 13 Fields 14 Forbes 15 Hess 16 Jared 17 Johnson 18 Mosley 19 Schiph 20 Singloop 21 Trout 27 Mistre 23 Winstead 24 Wise 25 Yoder True False C ID# Average 2692 2600 2633 2638 Before sorting 2561 2668 2537 2667 2752 2788 2741 275/9 2737 2350 2711 2589 2657 28:36 2644 . Grade 54% A 50% B 80%8+ 93% A 85%8 97% A 91%A 62% D 80% B 92% A SONIA 73% C 82% 0- 93% A- 99% A 89% 8 E 93%A 782/C+ 85%8 79% C Name 6 Singleton 7 Brownlee 8 Banks 9 bis 10 Schmidt 11 Walton 12 Hers 13 Eldred 14 Banjamin 15 Jared 16 Trout 17 Biggerstat 18 Boys 19 Whe 20 Masky 21 Forbes 22 oder 23 Winstead 24 Johnson 25 Fields ID# Average 2350 2561 2682 2638 After sorting 2589 2752 2668 1600 2788 2711 2638 2745 2836 2759 2067 2644 3667 2241 2537 D h Grade 99% A 97% A 94% A 93%A 93NA 93N A 92%A 91NA- 90% 8+ SONA 89N 84 BAN BING BSN B 82%8 SON 79 CH 78% C TINC 63% 0
Transcribed Image Text:In the image shown below, consider the data in the cell range B5:E25. It is possible to sort this data so that the Average column is sorted in descending order and then the Name column is sorted in alphabetical order to produce the results shown in the image below. O Name 6 Banies Benjamin Deperstaff 9 Blogs 10 Boyd 11 Brownlee 12 Eldred 13 Fields 14 Forbes 15 Hess 16 Jared 17 Johnson 18 Mosley 19 Schiph 20 Singloop 21 Trout 27 Mistre 23 Winstead 24 Wise 25 Yoder True False C ID# Average 2692 2600 2633 2638 Before sorting 2561 2668 2537 2667 2752 2788 2741 275/9 2737 2350 2711 2589 2657 28:36 2644 . Grade 54% A 50% B 80%8+ 93% A 85%8 97% A 91%A 62% D 80% B 92% A SONIA 73% C 82% 0- 93% A- 99% A 89% 8 E 93%A 782/C+ 85%8 79% C Name 6 Singleton 7 Brownlee 8 Banks 9 bis 10 Schmidt 11 Walton 12 Hers 13 Eldred 14 Banjamin 15 Jared 16 Trout 17 Biggerstat 18 Boys 19 Whe 20 Masky 21 Forbes 22 oder 23 Winstead 24 Johnson 25 Fields ID# Average 2350 2561 2682 2638 After sorting 2589 2752 2668 1600 2788 2711 2638 2745 2836 2759 2067 2644 3667 2241 2537 D h Grade 99% A 97% A 94% A 93%A 93NA 93N A 92%A 91NA- 90% 8+ SONA 89N 84 BAN BING BSN B 82%8 SON 79 CH 78% C TINC 63% 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer