Question

answer me this question please​

Answer 1

Answer:

At first go to “Sort & Filter” option in “Data”, and click on sort option there as shown below. Now select the column “area” and click on the drop down in order field, now click on the option “custom”. One pop up window will appear as shown below, there any desired order can be given.

Explanation:

plz mark it as brainliest and folow me pleasee.

Answer 2

The filter tool gives you the ability to filter a column of data within a table to isolate the key components you need. The sorting tool allows you to sort by date, number, alphabetic order and more. In the following example, we will explore the usage of sorting and filtering and show some advanced sorting techniques.

Sorting Data

Let’s say you had the spreadsheet above and wanted to sort by price. This process is fairly simple. You can either highlight the whole column or even click on the first cell in the column to get started. Then you will:

• Right click to open the menu
• Go down to the Sort option – when hovering over Sort the sub-menu will appear
• Click on Largest to Smallest
• Select Expand the selection
• Click OK
• Sorting & Filtering GIf 1

The whole table has now adjusted for the sorted column. Note: when the data in one column is related to the data in the remaining columns of the table, you want to select Expand the selection. This will ensure the data in that row carries over with sorted column data.

Filtering Data

The filter feature applies a drop down menu to each column heading, allowing you to select specific choices to narrow a table. Using the above example, let’s say you wanted to filter your table by Company and Salesperson. Specifically, you want to find the number of sales Dylan Rogers made to Eastern Company.

To do this using the filter you would:

• Go to the Data tab on Excel ribbon
• Select the Filter tool
• Select Eastern Company from the dropdown menu
• Select Dylan Rogers from the Salesperson dropdown menu
• Sorting & Filtering GIF 2

• Boom – you now have the exact number of sales Dylan Rogers made to Eastern Company.