Question

Tick the correct answer
by which of the following feature of Exel helps to
view the data in a Certain order
i > Filtering (2)Sorting (3) Autofill (4) None of these
​

Answer 1

Answer :

(2) Sorting Data

Step - By - Step Explaination :

The sort function in Excel arranges the data according to a certain criteria or order helping to view the data arranged in a convenient form .

These can be :

• Sorting the data according to ascending or descending order

• Sorting the data accounting to row number

• Sorting w.r.t frequency

etc

Steps to apply sorting In Excel :

1. Select the cell or column which has to be sorted

2. Open the data tab ; and in the sort & filter group, select the filter that you want to use .

3. Click apply

This will apply the sort and filter function according to the selected filter.

______________________________________________