Page 78 - IT-802_class_12
P. 78
6 Click on the OK button.
3
4
5
6
The result after sorting appears as:
3.7.3 Sort by Selection
In Office Calc, we can also sort the data by selecting a range of data. This is not a recommended method while working
in the original worksheet, as some of the relevant data is replaced by the newly sorted data. This causes the selected
data to be left unsorted and the copy of the sorted data to be copied to the specified location. Therefore, it is suggested
to apply this sorting to the duplicate copy of the worksheet.
The various options for sorting in the options tab are:
Ð ÐCase Sensitive: The letter in uppercase is placed after the letter in lowercase if the sort is ascending, and vice versa
if the sort is descending, if the cells to be sorted contain the same letter in the same position but differ in case.
Ð ÐDirection (sorting by rows or columns): It selects whether sorting is to be performed row-wise (vertically) or
column-wise (horizontally).
3.8 fIlTERING DATA
Filtering is a quick and simple approach to identifying and working with selected data based on the criteria you specify.
The filter feature allows you to selectively exclude the data you do not want to see and only display the rows or columns
that meet the criteria you specify. Sorting rearranges the range of cells, but filtering only temporarily hides the rows or
columns you do not want.
Different ways in which filtering can be done in Calc are:
Ð ÐAutoFilter
Ð ÐStandard Filter
76 Touchpad Information Technology-XII

