Question: Please see the attached Excel workbook image in answering this question. In order to sort the 'Salesperson' column in a descending order, which of the
Please see the attached Excel workbook image in answering this question. In order to sort the 'Salesperson' column in a descending order, which of the following steps is correct?
Question options:
Click on any cell containing Salespersons data, from the Ribbon pick the Data tab, and then click on the "Sort Z to A command button
Select the entire Salesperson Column, then Click on the Review tab in the Excel ribbon followed by clicking on Group and "Sort"
The Salesperson column cannot be sorted
Convert the data into a Table, right click on the Table header and select the AtoZ sort option
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
