Page 280 - open office
P. 280

CELL REFERENCING
              We know that a cell address is a combination of a column name and a row number such as A5, B12, H23,
              etc. Using a cell address in a formula or a function is known as a cell reference. There are three types of cell
              referencing which are as follows:

                 Relative Referencing: Whenever a formula or function is copied to some other cell, the address in the
                 formula or function changes relative to the location where it is copied. This is known as relative referencing.
                 In a spreadsheet, cell referencing by default is relative cell referencing. For example, a formula for calculating
                 the Profit or  oss is written in cell F  as  E -D . If we copy this formula two cells up (i.e., cell F ), then the
                 row number will decrease by 2 and the new formula in cell F  will be  E -D .

                 Absolute Referencing: Sometimes, we do not want the address in the formula to change with respect
                 to the location and we need to fix a cell. Thus, if we copy the formula anywhere across a worksheet, the
                 cell address in the formula does not change. This fixing of a cell in a formula/function so that its location
                 does not change with respect to the location where it is copied, then this type of referencing is known as
                 absolute referencing. The dollar sign ($) is used in front of a column name and a row number to make it an
                 absolute cell reference, like $A$10, $F$12, etc.
                 Mixed Referencing: The combination of a fixed row and a relative column like R 5, E 1 ,   23, etc. or a
                 fixed column and a relative row like  F12,  R ,  H , etc. in a cell referencing is known as mixed referencing.

                AUTO FILL
              It is an additional feature in the spreadsheet package like ‘Calc’ in
              which a certain kind of predefined series of data such as name of
              months of a year, serial numbers, etc. are automatically generated
              once the user feeds the initial data. For example:                                               Auto
                                                                                                                Fill
              To print a series of months of the year:                                                        Handle
              Step 1:  Type the initial data (month name) of the series in one cell.

              Step 2:   Select the cell. An AutoFill handle (a small black plus sign)
                      appears on the bottom-right corner of the selected cell.                                 Drag
              Step 3:   Click the Auto Fill handle tool and drag it over the range of
                      cells to fill the defined series and then release the mouse
                      button. The series of months will be displayed.

              (The given series is displayed because it is pre-defined/stored as a custom list)
              To create a Numeric data series:

              Step 1:   Enter the first two values of the series in adjacent cells. The difference between
                      the two numbers specifies the increment/decrement value, and the first number
                      determines the starting number for the series.

              For example, if the first two numbers are 1  and 15, then increment value is 5 and the
              starting number is 10.
              Step 2:   Select the first two cells and click the  AutoFill  handle tool and drag it to enclose
                      the cells to be filled with the series of numbers.
                                                                                                                 Drag
              Step 3:  Release the mouse button.




               280      Touchpad Information Technology-IX
   275   276   277   278   279   280   281   282   283   284   285