Question

2. What do you mean by sorting data? Write the steps to sort data on the basis of multiple
columns in a worksheet.
What is the use of Filter feature in Excel? Write the steps to filter data on the basis of​

Answer 1

Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. ... sort text data into alphabetical order. sort numeric data into numerical order.

Answer 2

Sorting involves putting information in an organized order so that you can more efficiently analyze it. The steps to sort data on the basis of multiple columns in a worksheet are as follows:

• Select Sort from the Data menu, then enter as many sorting tiers as necessary.
• After sorting the data, choose the range of ties and repeat the process.
• After sorting by the first column, choose the second column and repeat the process.

• You can use the FILTER function to filter a variety of data according to parameters that you specify. You can use filters to condense the data in your worksheet so that you can only see the information you require.

The steps to filter data on the basis of​ multiple columns are as follows:

• Click the Filter command after choosing the Data tab. There will be a drop-down arrow in each column's header cell.
• To filter a column, click the drop-down arrow next to it.
• There will be a Filter menu displayed.
• Click OK when it is done.
• The search term will be used to filter the worksheet.

For more information on Filter and Sorting data in Excel, Go through the following links:

https://brainly.in/question/30304682

https://brainly.in/question/43568284

#SPJ3