Page 282 - Computer - 9(A&B)
P. 282
Name the following:
You can also press Ctrl+D to fill the
1. A feature that helps to display multiple lines in a formula down in a column. First select
single cell. __________________
the cell that has the formula you want
2. A feature that helps to rotate the text in different to fill, then select the cells underneath
directions. __________________ it, and then press Ctrl+D.
Session 4
Understand and apply Referencing
The formulas used in Calc are dynamic in nature. This means that the value of the result is recalculated
automatically, if the values in any of the source cells are modifi ed. This is achieved by using cell references in
formulas instead of actual values. A reference identifi es a cell or a range of cells in a worksheet and tells Calc
where to look for the values or data used in a formula.
Cell reference in formulas in Calc is of three types:
v Relative reference v Absolute reference v Mixed reference
Relative Reference
Relative reference is the default cell reference used in Calc. In relative reference, cell references of the cells
containing the data change when the formula is copied from one cell to another cell. The references are changed
with respect to the new cell where the formula is copied. This is especially useful when the same formula is to be
entered in many cells and only the references of the cells containing the data values need to be changed.
Absolute Reference
An Absolute reference is a cell reference in a worksheet that remains constant even if the formula is copied or
moved from one cell to another cell. A cell reference is made absolute by putting a dollar sign before the column
letter as well as the row number of the desired cell, such as $B$4. This reference is used when we want to refer
to the same cell address in the formula copied to all cells.
In the above example, when we copy the formula =B2*C2-$D$2 from the cell E2 to cell E3, the absolute cell
reference ($D$2) remains same.
144
144