Page 251 - IT_Play_V1.0 Class9
P. 251

UNIT-4 ELECTRONIC SPREADSHEET





               4              UNDERSTAND AND APPLY

                              REFERENCING









                 Cell referencing in LibreOffice Calc is a method used to link the formula or function  in one cell to
                 another cell along the row or column. This allows users to apply formulas efficiently across multiple
                 cells.  There are three  types  of  cell  referencing  in  LibreOffice  Calc:  Relative Referencing,  Absolute
                 Referencing, and Mixed Referencing. Each type serves a different purpose, providing flexibility in how
                 formulas are applied and adjusted within a spreadsheet. Additionally, users can create and use custom
                 lists to further enhance data management and organisation.

                   CELL REFERENCING

                 Referencing is the way to refer the formula or function of one cell to other cell along the row or column.
                 There are three types of cell referencing in ‘LibreOffice Calc’.


                   Relative Referencing                   Absolute Referencing                  Mixed Referencing
                   RELATIVE REFERENCING

                 Relative referencing is the default type of referencing in LibreOffice Calc. It means that when you copy a
                 formula from one cell to another, the cell references in the formula change according to their relative position.

                 In simple words, relative referencing adjusts the cell reference based on where the formula is copied. For
                 example, a formula in the cell D2 is ‘=A2*B2-C2’ and it is to be applied to other cells i.e. D5. Here, the new
                 expression of the formula gets changed under the change in position of the cell, i.e. the formula in the cell
                 G5 will become as =A5+B5*C5.













                   ABSOLUTE REFERENCING

                 Absolute referencing is a way to keep a specific cell reference fixed, no matter where you copy the formula.
                 This means that when you copy a formula with an absolute reference to another cell, the reference does not
                 change.

                    In simple words, you can fix the row and column of a cell by using a dollar sign ($) before both the column
                   letter and the row number.






                                                                                Understand and Apply Referencing    249
   246   247   248   249   250   251   252   253   254   255   256