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

