Reference no: EM131827158

The sort and filter option is a useful tool when modifying raw data into an organized format. Prior to the lesson, I have only used the sort option a few times to organize Items in alphabetical order from A to Z or in the reverse. Being able to apply filters to sort data specifically can enhance a spreadsheet, depending on what the user is doing.

An example of this would be if there is a quarterly financial report listing multiple expenses for that particular quarter, with the report having multiple columns with corresponding values and their meaning for each expense. One of the options would be to simply alphabetize the list of expenses by the name of the expense. Another option would be to apply a kind of filter in the custom sort option to sort the table by the values of the other columns. So instead of having an alphabetized list, your report could be organized by expense amount from highest to lowest. Another way to filter the list in this scenario could be annual projections for the expenses, or even the percentage of the annual budget each expense consumes.

What I like is that the custom filter option is that it is not difficult to use since the feature bases it's sort options from the format of the data in the user's table just like the charts do. That cuts out the extra effort of having to manually sort the table the way the user sees fit. I didn't have any complaints about the feature at all.

GIVE A RESPONSE.