Question

Filter option is available in dash group under the under the data tab

Answer 1

Explanation:

Select the column or row you wish to sort. From the Sort & Filter button in the Editing group in the ribbon, click the Filter button. When the Filter menu appears, you can choose which categories of data to hide and deselect the appropriate buttons

Answer 2

Filter option is available in Sort and filter group under the under the data tab

Explanation:

• The filter option in the excel sheet allows the user to view only the needed information.

• The data that is not required will be hidden.

• To filter out the data, first we need to select the range of data on which  the filter must be applied and the select the data that has to be filtered

• For example , in column that is contains the names of fruits you can filter out specific fruit name like mango.

• Ctrl + T or Ctrl + L shortcut can be used to apply filter on the selected data range or column

Learn more about of filters:

Difference between sorting and filtering in excel

https://brainly.in/question/8773232

There are two types of filters in MS Excel, true or false​

https://brainly.in/question/11325385