Question

Write the steps to sort and filter data

Answer 1

To sort multiple levels:

Click the Sort & Filter command in the Editing group on the Home tab.

Select Custom Sort from the list to open the dialog box. OR.

Select the Data tab.

Locate the Sort and Filter group.

Click the Sort command to open the Custom Sort dialog box.

Answer 2

Following are the steps to sort and filter data  is given below

Explanation:

Following are the steps to sort the data in excel

• Choose the range of cell  for which you sort.

• Choose the Data tab and click on the Sort command. After that there is dialog box is appear in the screen.

• Choose the sorting as per the requirement (ascending or descending) and then finally click ok.

Following are the steps to Filter data in excel

• Choose the range of cell  for which you filter.

• Choose the Data tab and click on the filter and Sort command. After that there is dialog box is appear in the screen.

• Choose the filter option as per the requirement (custom or normal) and then finally click ok.

Learn More:

• brainly.in/question/2971975
• brainly.in/question/11366332