DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.
|
|
Ascending Sort
|
|
|
Descending Sort
|
|
|
Escalating Sort
|
|
|
Elevator Sort
|
Explanation:
Detailed explanation-1: -Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.
Detailed explanation-2: -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-3: -The fastest way to sort alphabetically in Excel is this: Select any cell in the column you want to sort. On the Data tab, in the Sort and Filter group, click either A-Z to sort ascending or Z-A to sort descending. Done!
There is 1 question to complete.