Question

answer me this question please no spam answer​

Answer 1

1) To sort a range:

1. Select the cell range you want to sort. ...
2. Select the Data tab on the Ribbon, then click the Sort command.
3. The Sort dialog box will appear. ...
4. Decide the sorting order (either ascending or descending). ...
5. Once you're satisfied with your selection, click OK.
6. The cell range will be sorted by the selected column.

2) To filter data:

1. Begin with a worksheet that identifies each column using a header row. ...
2. Select the Data tab, then locate the Sort & Filter group.
3. Click the Filter command. ...
4. Drop-down arrows will appear in the header of each column.
5. Click the drop-down arrow for the column you want to filter. ...
6. The Filter menu appears.