Question

what is the sort and filter option​

Answer 1

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.

Answer 2

Answer:

To sort from smallest to largest:

Select a cell in the column you want to sort (a column with numbers). Click the Sort & Filter command in the Editing group on the Home tab. Select From Smallest to Largest. Now the information is organized from the smallest to largest amount.