Multi-sorting data:
Step 1: Select Data ➝ Sort. Name are arranged in Ascending order According to names, other data also rearranged
Step 2: Sort dialog box appears.
Step 3: Select the field name (Student name) in which you want to sort from the "sort by" dropdown list box and then choose order of sorting i.e. Ascending or Descending. Ascending is the default selection.
Step 4: Select another field name (Group Code) from the "Then by" dropdown list box and choose the order of sorting to this column.
Step 5: Click "OK" button. In OpenOffice Calc, multi-sort can be done only for three fields.

Direct Insert method:
If you know the function name and its syntax known, it can be directly typed in any cell of the worksheet.
For example, SUM is the most frequently using function to add a set of values. The syntax of the SUM () is
= SUM (range 1; range 2; range 3 range n)
** (Remember that the meaning of Range explained previously in this chapter)
To find the sum of the values on A1, A2, A3, A4, A4 in AS, Place your cell pointer in AS and directly type the formulae as follows.
= SUM (A1: A4)
While directly typing a function the following points should be kept in mind.
(i) A function should begins with a equal sign.
(ii) Use proper name of the function to be used.
(iii) Within brackets, arguments should be given as per the syntax. Each function has unique argument list.
(iv) After typed a function, "Enter" key must be pressed.

Copy and Paste Data:
(i) Select the cell or cells you want to copy
(ii) Select Edit ➝ Copy or Click "Copy" icon from the standard toolbar or Press Ctrl + C
(iii) Move the cell pointer to the cell in which you want to paste.
(iv) Select Edit ➝ Paste or Click "Paste" icon or Press Ctrl + V
Cut and Paste Data:
(i) Select the cell or cells you want to cut
(ii) Select Edit ➝ Cut or Click "Cut" icon from the standard toolbar or Press Ctrl + X
(iii) Move the cell pointer to the cell in which you want to paste.
(iv) Select Edit ➝ Paste or Click "Paste" icon or Press Ctrl +V

Sheets count: Shows current serial number of the sheet / total number of sheets available.
Page Style: Shows the page style of the current sheet. To make changes, just double-click on "Default" and it will show you the "Page Style" dialog box, which is used to change the margin, orientation, paper size, inserting header, footer, border style etc., 
Selection Mode: Shows the selection mode of the current sheet. There are three modes available to select the cells of a worksheet. They are, Standard (STD), Extend (EXT) and Add (ADD).
Unsaved Changes: An asterisk ( * ) symbol indicates the changes made in the worksheet that are not yet saved. If you saved your changes, it will disappear.
Cell information: Shows the sum of the values of selected cells.
Zoom slider: used to increase or decrease the view scale (zoom). The default zooming scale is 100%.

(i) Title Bar
(ii) Control Buttons
(iii) Menu Bar
(iv) Tools Bar
(v) Name Box / Address Box
(vi) Quick Function Wizard
(vii) Formula Bar / Input Line
(viii) Formatting Properties
(ix) Zoom
(x) Scroll bar
(xi) Status Bar