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
   277   278   279   280   281   282   283   284   285   286   287