This data needs to be sorted by Group, then by Last Name, then by First Name. How do you accomplish this?

🎲 Try a Random Question | Total Questions in Quiz: 119 | 🧠 Study this quiz with Flashcards

This question is part of a full practice quiz:

Microsoft Excel Test — practice the complete quiz, review flashcards, or try a random question.

🧠 Flashcards (fast review) 🧪 Practice Quiz ⚔️ Challenge a Friend 🥊 📊 View Stats

Microsoft Excel MCQs For LinkedIn Skill Assessments.

This data needs to be sorted by Group, then by Last Name, then by First Name. How do you accomplish this? <img src='https://www.fatskills.com/images2/microsoft-excel/Q81.png' >

D 1. Select a cell in the Group column, then sort. 2. Select a cell in the Last Name column, then sort. 3. Select a cell in the FIrst Name column, then sort.
A 1. Rearrange the columns in this order: Group, Last Name, First Name. 2. Right-click any of the headers. 3. Select _Sort All_.
B 1. Select any cell in the dataset. 2. In the _Data_ tab, click the _Sort_ button. 3. Add two levels to the default level. 4. Populate the _Sort-by_ fields in this order: Group, Last Name, First Name.
C 1. Highlight the entire dataset. 2. In the _Data_ tab, click the _Sort_ button. The headers appear. 3. Drag the headers into this order: Group, Last Name, First Name.

This data needs to be sorted by Group, then by Last Name, then by First Name. How do you accomplish this?

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

This data needs to be sorted by Group, then by Last Name, then by First Name. How do you accomplish this?

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know? Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com