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

