In: Computer Science
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?
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.
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. ...
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.