DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Ascending
|
|
|
Descending
|
|
|
Fescending
|
|
|
Sescending
|
Detailed explanation-1: -On the Data tab, in the Sort & Filter group, click. to perform an ascending sort (from A to Z, or smallest number to largest). Click. to perform a descending sort (from Z to A, or largest number to smallest).
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: -Examples. Sort a range of values in descending order. Use SORT and FILTER together to sort a range in ascending order, and limit it to values over 5, 000.
Detailed explanation-4: -Ascending order means to arrange numbers in increasing order, that is, from smallest to largest.