Page 68 - IT-802_class_12
P. 68
Lab Assignment ‘n Activity Subject Enrichment
Open OpenOffice Calc and create a new worksheet. Now, perform the following operations:
Ê ÐSelect cell A5.
Ê ÐSelect the range of cells from A4 to D9.
Ê ÐSelect the range of cells from B4 to F5.
Ê ÐSelect multiple range of cells C3:E8 and A5:D9.
Ê ÐSelect row 10.
Ê ÐSelect row 5 and 12.
Ê ÐSelect column E.
Ê ÐSelect column C and F.
3.5.3 Inserting Cells
A worksheet consists of innumerous cells, but while working, a user may be required to fill more data in new cells that
may be in between existing cell contents. A spreadsheet provides such a facility where a user can insert new cells,
rows, or columns.
To insert additional cells in between the existing worksheet:
1 Click on the place where the cell/cells have to be inserted.
2 Click on Cells from the Insert menu. The Insert Cells dialog box opens.
3 Select the desired option.
4 Click on the OK button to add a new cell in a worksheet.
4
3
To insert a new row in a worksheet:
1 Click on the cell in the row above which a new row is to be inserted.
66 Touchpad Information Technology-XII

