Spreadsheet में default cell reference type है।

Formula copy करने पर cell reference automatically change हो जाता है।

Useful है एक ही calculation को multiple rows या columns में apply करने के लिए।

Example:

• Formula in C2: =A2+B2

• Copy formula down to C3 → automatically =A3+B3

• Copy formula to next column D2 → references adjust automatically

Relative references formula वाली cell की position पर depend करते हैं।

Calculations में समय बचता है।

Automatic adjustment → manual errors कम।

Large datasets में बहुत useful।

Spreadsheets dynamic और flexible बनती हैं।

D2 में formula: =B2*C2

Fill Handle drag down → automatically:

• D3: =B3*C3

• D4: =B4*C4

Manual typing की जरूरत नहीं।

Relative Reference → formula copy करने पर reference automatically बदल जाता है।

Useful है repeating calculations के लिए।

समय बचता है और errors कम होते हैं।

Relative referencing is the default type of cell reference in spreadsheets.

The cell reference changes automatically when a formula is copied to another cell.

It is useful for applying the same calculation to multiple rows or columns.

Example:

• Formula in C2: =A2+B2

• Copy formula down to C3 → formula automatically becomes =A3+B3

• Copy formula to the next column D2 → formula automatically adjusts references as per new column

This happens because relative references depend on the position of the cell containing the formula.

Saves time in calculations.

Automatic adjustment reduces manual errors.

Useful for large datasets where same formula applies to many cells.

Makes spreadsheets dynamic and flexible.

Formula in D2: =B2*C2

Drag Fill Handle down → automatically calculates:

• D3: =B3*C3

• D4: =B4*C4

No need to type formulas for each row manually.

Relative Reference = cell reference changes automatically when formula is copied.

Useful for repeating calculations across rows or columns.

Saves time and reduces errors.