Active cell is identified by cell pointer. Cell pointer is located in cell A1, then A1 is called Home cell.

(i) Move to the First sheet
(ii) Move to the previous sheet
(iii) Move to Next sheet
(iv) Move to the Last sheet

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.

Spreadsheet is a software package and worksheet is a file created using spreadsheet software.

Step 1: Select the column where you want the new column should be inserted.
Step 2: Right-click on the column name that you selected. A pop-up menu will appear.
Step 3: click the "Insert Columns" option from the menu

Step 1: Copy the formula from H2 using Ctrl + C or Edit ➝ Copy (or) click "Copy" icon.
Step 2: Select all cells (i.e. H3 to H11) in which you want to paste this addition formula.
Step 3: Paste the copied formula using Ctrl +V or Edit ➝ Paste (or) Click "Paste" icon.

(i) .odt - Openoffice Documents
(ii) .ods - Openoffice Calc
(iii) .odp - Openoffice Impress

There are three types of reference operators that are used to refer cells in calc; They are
(i) Range Reference Operator,
(ii) Range Concatenation
(iii) Intersection Operator.

Step 1: Click fx icon from Formula bar (or) choose Insert ➝ Functions (or) Press Ctrl +F2.
Step 2: Pull down category list box, Choose the type of functions "Mathematics"; All function under Mathematics category displayed in "Functions" list box.
Step 3: Scroll the "Functions" list box and select the type of function. The selected function and wizard shows description about the selected function on the right comer of the dialog box.
Step 4: Click ''Next'' command button.
Step 5: Type cell address according to the function selected or click Select cell button., Now, Function Wizard will be shrinked, and displayed as a floating toolbar as with the selected function.
Step 6: Click on the cell which is contains the value according the function selected. Now, Minimized wizard shows the cell address selected.
Step 7: Click "Maximize" button to display full wizard. Now, Function wizard appears.
Step 8: Directly type the cell address according to the selected function.
Step 9: Result Function box at the top right comer is also shown the result of the function. If you agreed the result, click "OK" button. If you click "Back" button, it will display the previous page of this wizard.

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.