Page 98 - IT-802_class_12
P. 98

3.12.3 Mixed Referencing

        In mixed referencing, one part of the cell address in the new formula, i.e., either row number or column name, is fixed
        but the other part changes with the change in address. In this type of referencing, the user can change the address of
        either row or column and keep the other one fixed. For example, $D2 means that column D is absolute and row 2 is
        relative. Consider the given worksheet:

        Say, in a worksheet, the formula in cell E3 is given as =D3*200 and when copied to F3, it changes to =E3*200, as it
        is relative referencing. On the other hand, the formula in cell E5 is given as $D5*200. When copied to cell F5, it will
        remain unchanged as $D5*200 as it is absolute referencing. Here, D is fixed and the row part is relative.

                                         Lab Assignment ‘n Activity                              Subject Enrichment




              Create the following worksheet in Calc and perform the given operations:














              Ê ÐEnter any 5 entries for Length and Breadth columns.

              Ê Ð Write the formula in cell C3 to calculate the area of a rectangle according to the length and breadth
                 given in cells A3 and B3, respectively. Then, press the Enter key.

              Ê ÐCopy the formula to cells C4, C5, C6, and C7.

              Ê Ð Write the formula in cell D3 to calculate the area of a rectangle according to the length and breadth
                 given in cells A3 and B3, respectively. Then, press the Enter key.

              Ê ÐNow, copy the formula in cell to D4, D5, D6, and D7.
              Ê ÐSave the worksheet as Area Calculator.



          3.13 PROTECTING CAlC DOCUMENT WHIlE SAVING

        In OpenOffice Calc, there is an option where we can save the document using a password. It helps to protect and avoid
        unnecessary modification of the contents and the format of all the cells. Protection of a sheet prevents modification of
        the contents and format of all the cells of that sheet also. To do so, follow the given step:
         1   Select the contents and cells in the spreadsheet.

         2   Select Cells option from the Format menu.












          96    Touchpad Information Technology-XII
   93   94   95   96   97   98   99   100   101   102   103