Question

in ___ refencing both column part and row part are not fixed. a relative referincing b absolute referencing c mixed referencing. ​

Answer 1

In relative referencing, both column part and row part are not fixed.

Relative referencing:

• In Excel, the default cell reference is a relative reference.
• Without the dollar ($) sign, it is simply the combination of the column name and row number.
• The relative cell address varies based on the relative positions of the column and row when a formula is copied from one cell to another.
• Examples of relative cell designations include C1, D2, E4, etc.
• When we wish to perform the same action on numerous cells and the formula must change based on the relative address of the column and row, we utilize relative references.
• For instance, we want the results of adding the marks from two subjects entered in columns A and B to be displayed in column C.
• In this case, we'll utilize a relative reference to add the same rows to columns A and B.

Steps involved:

1. To calculate the formula, input it in any cell and then hit return.
2. In order to calculate the formula in this example, insert the formula (= B2 + A2) in cell C2.
3. To fill the cell with the formula, click on the Fill handle at its corner (C2).
4. You can fill cells by dragging the Fill handle up to them.
5. Drag it until cell C10 in our example.
6. At this point, it is clear that the addition operation is carried out between cells A2 and B2, A3 and B3, and so on.
7. Any cell can be double-clicked to verify which cells are used for the action.

As a result, in the example above, we can see that depending on the relative location of the row, the relative address of cell A2 changes to cells A3, A4, and so on.

Hence, in relative referencing both column and row parts are not fixed.

#SPJ2