USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you want to put your data into alphabetical order by last name, you could use the ____ command.
|
|
Shift
|
|
|
Font
|
|
|
autofill
|
|
|
Sort
|
Explanation:
Detailed explanation-1: -In the Sort dialog box, make sure ‘My data has headers’ is selected. In the ‘Sort by’ option, select the name of the column that just has the last name. In the ‘Sort On’, select ‘Cell Values’ In the Order option, select ‘A to Z’
Detailed explanation-2: -In Python, sorting a list alphabetically is as easy as passing a list of strings to the sorted() method. Strings are sorted in alphabetical order based on their first letter (A-Z).
Detailed explanation-3: -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!
There is 1 question to complete.