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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock