Page 36 - Touchpad_Plus_V3.2_Class 7
P. 36
3 More on Calc
Your Aim
to learn about:
Sorting Data Filtering Data
Conditional Formatting Goal Seek
Printing a Worksheet
In the previous class, you have learnt how to format a Calc worksheet. Suppose, you have to highlight
cells that contain values greater than a particular value or sort data in ascending or descending
order. Calc provides you easy options for doing these types of formatting on a worksheet.
SORTING DATA
Calc can arrange the selected data in ascending or descending order. This is called sorting of
data. Perform the following steps to sort data:
Step 1 Select the data to be sorted.
Step 2 Click on the Data menu.
Step 3 Select the Sort Ascending or Sort Descending option to sort the data in ascending or
descending order respectively. In case of numbers, the ascending order is from 0 to 9
and in case of letters the ascending order is from A to Z. The data gets arranged in the
selected order.
Unsorted data Using Data menu Sorted data (ascending)
34 Plus (Ver. 3.2)-VII

