DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -Go to the Data tab. Go to the Sort & Filter group. Here you can select either the Sort A to Z or Sort Z to A button to sort in ascending or descending order. Blank rows will be sorted at the bottom of the selected range (indicated by colored rows in the screenshot 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.