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
Related questions
Question
please answer my simple excel question accurately

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
