Page 87 - 2619_PlusGPT V2.1_C-7

Relative References

By default, all cell references in Google Sheets are relative references. This means that when you
copy a formula across different cells, the references will automatically adjust based on their new
position in the sheet.

For example, if you copy a formula with a relative reference from one cell to another, the references
in the formula will change according to the new row or column. This helps keep the calculations
correct, depending on where the formula is copied.

To use relative reference, follow the given steps:
Step 1: Select the cell that contains the formula for the reference of other cells.
Step 2: Move the mouse pointer at the bottom right corner of the cell. The shape of the pointer
will change to + sign.

Step 3: Drag the mouse till the last cell upto which you want to apply the formula.
The formula will be applied to the cells.

21 st
Let’s PraCtiCe Century #Critical Thinking
Skills
If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
the following formulas:

1. (A1 - A2) * A3 _______________________________________________________
2. A3 + (A1 * A2) _______________________________________________________

3. A1 * (A2 + A3) – 10 _______________________________________________________

Formulas and Functions in Google Sheets 85