Question

4
Write steps to create a custom list of your five friends by importing the items
5. How will you sort data on one column in ascending order quickly?​

Answer 1

Answer:

Select the columns to sort. ...

In the ribbon, click Data > Sort.

In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort. ...

From the Order drop-down, select Custom List.

In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.

Answer 2

4. The steps to create a custom list are —

Step 1: In a column of a worksheet, type the values to sort by.

Step 2: Select all of the cells in that list, and then click File > Options > Advanced.

Step 3: Scroll way down to the General section and click Edit Custom Lists.

Step 4: In the Custom Lists box, click Import.

5. The steps to sort data on one column in ascending and descending order are —

Step 1: Select a cell in the column you want to sort.

Step 2: On the Data tab, in the Sort & Filter group, to quick sort in ascending order, click Sort A to Z. And, to quick sort in descending order, click Sort Z to A.