Question

A worksheet has data fields- subject and marks. How will you sort the data in descending order of marks

Answer 1

Explanation:

Select the column that you want to sort

1.Go to Data tab

2.In Sort & Filter group, you will see two buttons: A to Z(for ascending sort order) and Z to A (for descending sort order). Ascending order will sort data from smaller to higher values. Descending order will sort data from higher to smaller values

3.Click on either of these two buttons as required and the selected column will get sorted accordingly.

Answer 2

Answer:

Explanation:

1. Select the column that you want to sort.

2. Go to Data tab.

3. Select sort and filter group, you will see two buttons : A to Z and Z to A.

4. Click either A to Z for ascending order or Z to A for descending order.