USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Home
|
|
|
Data
|
|
|
Insert
|
|
|
View
|
Detailed explanation-1: -Select the Data tab on the Ribbon, then click the Sort command. The Sort dialog box will appear. Choose the column you want to sort by.
Detailed explanation-2: -On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window. In the Sort by dropdown list, select the first column on which you want to sort. In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon.
Detailed explanation-3: -Answer: To sort data, we use data tab on the ribbon.
Detailed explanation-4: -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. For example, if you want to re-sort the previous example by delivery date, under Sort by, choose delivery. From the Order drop-down, select Custom List.