Page 74 - IT-802_class_12
P. 74
Lab Assignment ‘n Activity Subject Enrichment
Create the following worksheet and perform the given operations:
Ê ÐInsert a column after column C.
Ê ÐMove the marks of Maths in the newly inserted column.
Ê ÐInsert a new row before last record.
Ê ÐInsert the following details in the new row
1006 Diya 70 85 69 65
Ê ÐChange the row height of all the rows.
Ê ÐChange the column width of columns A to F.
3.7 SORTING DATA
Sorting is the process of arranging and displaying the data in the worksheet as per the requirements of information, i.e.,
in an organised and meaningful order so that a user can view the required data to evaluate further. There are three types
of sorting in OpenOffice Calc. They are:
Ð ÐSimple sorting
Ð ÐMulti-sorting
Ð ÐSort by selection
3.7.1 Simple Sorting
Sorting the data on the basis of a single column is known as simple sorting. Simple sorting can be categorised into two
types.
Ð ÐSort Ascending: Such sorting enables us to display the data in order from small to large or in alphabetical order
(A to Z/Small to Large).
Ð ÐSort Descending: Such sorting enables us to display the data in order from larger value to smaller in reversed
alphabetical order (Z to A/Large to Small).
Sorting data can be easily done in Calc with the help of the Sort command from the Standard toolbar or from the Data menu.
To sort data in ascending or descending order, perform the following steps:
1 Select the desired cells to sort.
2 Click on the Sort Ascending icon or Sort Descending icon from the Standard Toolbar.
72 Touchpad Information Technology-XII

