USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Data in an excel table can be sorted in this way
|
|
large to largest
|
|
|
smallest to largest
|
|
|
small to smallest
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Select a single cell in the column you want to sort. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest). Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest).
Detailed explanation-2: -Re: Excel not sorting numbers correctly-smallest to largest etc. Click the info icon if there is a green box in the left of the cell and choose “convert to a number” for those that have it. If none, do nothing. Re-sort the column and verify that the sort worked correctly.
There is 1 question to complete.