Question

In: Computer Science

What sorts of sorting can we do? How about across multiple columns? What kinds of filters...

What sorts of sorting can we do? How about across multiple columns?

What kinds of filters can we put on data columns? Why would you use one process over another?

Solutions

Expert Solution

1) You can sort the data of one colomn or multiple column in ascending and descending order.

There are various types of sorting algorithms which can be used. However, the major and most used sorting algorithms are :

Selection Sort, Bubble Sort, Insertion sort, Merge Sort, Quick Sort, Heap Sort.

2) Quick sort is the best technique for sorting accross multiple columns.

Choose the cell within the data.

  1. Go to Home > Click Sort & Filter.
  2. SThen selectone of the options:
    Sort A to Z
    Sort Z to A
    Custom Sort

3) If there is lot of data on your worksheet you can apply filter and sort the data to get the best result.

To apply filter:

Select the Data tab, then click the Filter command. A dropdown will appear in the header cell for each column. ...

  1. Click the drop-down arrow for the column you want to filter.
  2. Filter menu will appear.
  3. Go to Custom AutoFilter dialog box will appear,
  4. When the Filter menu appears, you can choose which categories of data to filter and select the right opions.
  5. The data will be filtered as per the filter.

You can also use the same option from the Sort & Filter button in the Editing group in the ribbon,

4) Accessing the Data Tab and appying filter would be more usefull as you get an additiona option 'Advanced'.

The Advanced feature helps you get additional options to filter effectively, such options are:

a) Filter the list, in place. b) Copy to another location c) Unique records.


Related Solutions

What sorts of "assumptions" might we make about civics, citizenship, etc?
What sorts of "assumptions" might we make about civics, citizenship, etc?
Risk is inevitable. How do we measure it? What can we do to mitigate risk? How...
Risk is inevitable. How do we measure it? What can we do to mitigate risk? How is inventory level a prospective risk? How are accounts receivable a prospective risk
What kinds of program can we use GPU to optimize the performance?
What kinds of program can we use GPU to optimize the performance?
What sorts of limitations (i.e. LATE, attrition) do you expect for the experiment? What can be...
What sorts of limitations (i.e. LATE, attrition) do you expect for the experiment? What can be done to mitigate the effects of those problems?
1 How can we specify the number of rows and columns in a grid layout? 2....
1 How can we specify the number of rows and columns in a grid layout? 2. What happens when we don't have enough items to be displayed in a grid layout with a specified size? 3. How can we specify a grid layout component to occupy more than one columns or rows? 4. What happens if the components in a linear and grid layout exceed the layout size? How can we handle this problem so that all components can be...
. How can we promote healthy behaviors? What do you do?
. How can we promote healthy behaviors? What do you do?
Where do bank risks come from? What can we do about the risks?
Where do bank risks come from? What can we do about the risks?
In a multiple linear regression how do we calculate the standard error of B2 ( we...
In a multiple linear regression how do we calculate the standard error of B2 ( we have two independent variables and a constant so we have B0 B1 and B2) how do we calculate the standard error of the three.
What are three of the common search filters in search engine marketing? How do each of...
What are three of the common search filters in search engine marketing? How do each of these filters affect search output?
What are filters? How they are used for reclassification process.
What are filters? How they are used for reclassification process.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT