Question

Please give the detailed steps to
arrange data in ascending order in Excel 2010.​

Answer 1

Answer:

Sorting Data

StepsActions.

Select the column you want to sort by clicking the column letter.

Click the Home tab.

Click the Sort and Filter button from the Editing group.

Click if you want to order the data in ascending order, or click if you want to order the data in descending order.

Answer 2

Answer:

HOPE THIS HELPS YOU

Explanation:

Ordering: organizing items in a sequence ordered by some criterion like A to Z or vice versa and smallest to largest value or vice versa.

Categorizing: grouping items with similar properties like sorting on the basis of colour or value criteria.

In Microsoft Excel, we can sort the data by using the AutoFilter sort’s data according to specific sort order rules.

Let’s und excel with an example

Here we have two columns Item and Units.

We need to sort or filter Item and units. So we will select these two cells A1 and B1.

Click Home > Sort & Filter > Filter or use shortcut keys Ctrl+ Shift + L.