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

• [ 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.
• [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.

The correct answer is:

• [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.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers