USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Numbers are sorted from the smallest negative number to the largest positive number
|
|
|
When you sort text Excel sorts left to right character by character
|
|
|
In logical values, FALSE is placed before TRUE
|
|
|
Blanks are always placed first
|
Detailed explanation-1: -You cannot sort data by more than one column is not true about sorting data in Excel.
Detailed explanation-2: -Data is typically sorted based on actual values, counts or percentages, in either ascending or descending order, but can also be sorted based on the variable value labels.
Detailed explanation-3: -If you populate your blank cells in the column you are sorting by with ="", you can then sort by column choosing custom list in the order selection. In custom list, set the sort value to ="". This will sort with the blank columns on top and the columns with values below.
Detailed explanation-4: -Excel can arrange data in ascending and descending orders both. You can specify the order in which you want to sort the data. You can sort more than one columns at a time in selected range.