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
   63   64   65   66   67   68   69   70   71   72   73