= Average (A1 : A3) (or) = (A1 + A2 + A3) / 3 = 62.7%

(i) Bold
(ii) Italic
(iii) Underline

Insert a new column anywhere in the worksheet.
Step 1 : Select the column where a new column to be inserted.
Step 2 : Right–click on the selected column name that you selected. A pop-up menu appears.
Step 3 : click the "Insert Columns" option from the menu.
a new column will be inserted to the left of the current column. Insert a new row in the worksheet.
Step 1 : Select the row where a new row to be inserted.
Step 2 : Right–click on the row number, a pop-up menu appears.
Step 3 : click "Insert Rows" option from the menu a new row will be inserted to above the current row.

OpenOffice Calc is a popular open source spreadsheet application maintained by Apache Foundation. Star Office Calc is the parent application of OpenOffice Calc which was developed by a German Company namely, Star Division in 1985. Calc is the spreadsheet component of OpenOffice. You can enter any kind of data in a spreadsheet and then manipulate this data to produce certain results.

The steps to generate the series 5,10,20.......2560.
Step 1 : Select Edit → fill → Series Command. The fill series dialog log opens. In the dialog box.
Step 2 : Select Direction (Down / Right / Up / Left) in which the series to be displayed.
Step 3 : Select Growth to generate the series
Step 4 : Initial value of the series 5 should be typed in start value box.
Step 5 : End value of the series 2560 should be typed in End value text box.
Step 6 : Growth value of the series 2 should be typed in Increment text box.
Step 7 : Click OK to generate the series.

Changing Column Width and Row Height :
(i) Often while entering data into a worksheet you will realize that the width of the column is not enough.
(ii) StarOffice Calc. allows you to change the width of a column and the height of a row. To change the column width, select the column whose width you want to change.
(iii) Click on Format → Column → Width and type the new column width in the dialog box, which appears as shown in figure Click on OK.

(iv) You can also change the column width in another way. Point to the line separating the column whose width you want to change from the next column.
(v) The mouse pointer becomes a double – headed arrow. Click and drag this pointer to the left to decrease the width and to the right to increase the width.