Cell references are of two types
(i) Relative cell reference
(ii) Absolute Cell reference.

Calc calculates the results using the rule of precedence followed in Mathematics. The order is:
(i) Exponentiation ( ^ )
(ii) Negation ( - )
(iii) Multiplication and Division ( *, /)
(iv) Addition and Subtraction (+, -)

Multiple sheets can also be selected by clicking that sheet with simultaneously pressing the Ctrl button (Ctrl + Click). All selected sheets will turn to white colour.

Cell pointer is a rectangle element which can be moved around the worksheet.

Cell address is the combination of column heading and row number. For example, the intersection of column B and row 4 makes a cell B4.

In Calc, the functions are categorized as 11 types. They are,
(i) Database
(ii) Date and Time
(iii) Financial
(iv) Information
(v) Logical

(i) Insert Cells floating toolbar is also used to insert cells, rows and columns
(ii) Click View ➝Toolbars ➝ Insert Cell
(iii) A tiny floating toolbar appears on the screen with four icons; using these icons, you can insert cells, rows and columns.

Step 1: Select the row where you want the new row to be inserted.
Step 2: Right-click on the row number that you selected, A pop-up menu will appear
Step 3: click "Insert Rows" option from the menu.

The process of saving a worksheet is very similar to saving a document.
Steps to save a worksheet are as follows:
Step 1: File ➝ Save (or) Ctrl + S (or) Click "Save" icon on the standard tool bar.
Step 2: If the spreadsheet has not been saved previously, the Save As dialog box will appear.
Step 3: Type the name in "File Name" list box.
Step 4: Click "Save as type" list box. It shows all possible formats to save your file. From the list select "Microsoft Excel 97/2000/XP (.xls)" option, and then click "Save" button

To construct a formula, you should follow the steps below:
(i) Cell pointer should be in the cell in which you want to display the result.
(ii) Formula should begin with an = sign.
(iii) In a formula, use only cell reference (cell addresses) instead of the actual values within the cells.
(iv) While constructing a formula, BODMAS rule should be kept in mind.

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.

Generating whole number series:
Step 1: In cell A1, type as 1 (one) and press enter
Step 2: click A1 to place the cell pointer
Step 3: Click "Drag Fill Handle" of cell pointer; now the mouse pointer becomes a small +
Step 4: Drag over the cells; While dragging, the generated values will be displayed as tooltip.
Step 5: Leave the mouse pointer. Selected cells will be filled with series of values

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

There are three toolbars available by default. They are:
(i) Standard Toolbar
(ii) Formatting Toolbar
(iii) Formula bar
Standard Toolbar: contains frequently using File, Edit and Data menu commands as buttons (icons) such as New spreadsheet, Open an existing spreadsheet, Save, Send, print, print preview, Cut, Copy, Paste, Sorting, inserting chart etc.,

Formatting Toolbar - contains frequently using text and cell formatting commands as buttons such as changing font style, font size, font colour, alignments, cell formatting etc.,  
Formula bar - This is a very important element in a spreadsheet. It contains Name box, Function Wizard, Sum button, Function button and Input line.

Name box: It shows the current cell address
Function Wizard: Used to insert function.
Sum button: Used to - quickly insert sum function.
Function button: Used to input formula or function
Input Line: This is used to show the contents of the current cell. It always, shows actually what you typed in a cell. It is also used to edit the contents.