USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which command on the Home Ribbon do you use to organize data in ascending or descending order?
|
Find & Select
|
|
Format Cell
|
|
Sort & Filter
|
|
Organize
|
Explanation:
Detailed explanation-1: -In the ribbon, click Data > Sort. In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort.
Detailed explanation-2: -To organize your data in ascending or descending order, use the Sort Row command.
Detailed explanation-3: -Click the Home tab on the Ribbon, and locate the Sort & Filter group. Sort the field by selecting the Ascending or Descending command. The table will now be sorted by the selected field.
Detailed explanation-4: -Sort quickly 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).
There is 1 question to complete.