DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
large to largest
|
|
|
smallest to largest
|
|
|
small to smallest
|
|
|
None of the above
|
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: -Quick Sort With Sort Buttons Follow these steps to sort with the Quick Sort command buttons: Select one cell in the column you want to sort. On the Excel Ribbon, click the Data tab. Click Sort A to Z (smallest to largest) or Sort Z to A (largest to smallest)
Detailed explanation-3: -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.