USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Ascending
|
|
Descending
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -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: -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!
Detailed explanation-3: -Sort quickly and easily Select a single cell in the column you want to sort. to perform an ascending sort (from A to Z, or smallest number to largest). to perform a descending sort (from Z to A, or largest number to smallest).
Detailed explanation-4: -Arranging numbers in ascending order: Count the number of digits in each number. The number with the least number of digits is the smallest. Write it first. Continue this till all the numbers left for comparison have the same number of digits.