Page 252 - IT_Play_V1.0 Class9
P. 252

For example, a formula in cell D2 contains the formula =A2*B2-$C$2. Here, $C$2 is an absolute reference
                 to the discount rate. This means that when you copy the formula from one cell to another, the reference
                 to $C$2 remains constant, ensuring that all calculations use the same discount rate. When copying the
                 formula from D2 to D3, the formula will update to =A3 * B3 - $C$2. The row numbers change from A2 to
                 A3 and from B2 to B3, while $C$2 remains fixed.











                MIXED REFERENCING

              Mixed referencing is a type of cell referencing where either the row or the column is fixed, but not both. This
              allows you to control one part of the reference while letting the other part change when the formula is copied
              to other cells.
              For example, a formula in  cell D2  contains  the formula =$A2*$B2-$C$2.The column  ($A  and  $B)  is
              absolute which means that as you copy the formula across columns, the reference to columns A and B
              will not change. When copying the formula from D2 to D3, the formula will update to =$A3 * $B3 - $C$2,
              reflecting the change in row number while keeping the column references fixed.












                  Recap Zone


                  Relative referencing is the default type in LibreOffice Calc, meaning that when a formula is copied
                   from one cell to another, the cell references adjust according to their relative position.
                  Absolute referencing keeps a specific cell reference fixed, regardless of where the formula is copied,
                   by using a dollar sign ($) before both the column letter and the row number, such as in the cell
                   address $A$1.
                  Mixed referencing is a type of cell referencing where either the row or the column is fixed, allowing
                   one part of the reference to remain constant while the other changes when the formula is copied.





                                                          Exercise


                                                 Section A (Objective Type Questions)
              A.  Multiple choice questions.
                 1.   Which of these formulas uses mixed referencing?
                    i.  =$A2*B$2             ii.  =A1*B1              iii.  =$C$1*$D$2        iv.  =$A$1*$B$2






                250     Information Technology Play (Ver 1.0)-IX
   247   248   249   250   251   252   253   254   255   256   257