FUNDAMENTALS OF COMPUTER

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?
A
Find & Select
B
Format Cell
C
Sort & Filter
D
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.