Question

What is relative referencing ?​

Answer 1

Answer:

Answer:-

\red{\bigstar}★ \large\boxed{\tt\purple{x = 11}}

x=11

\red{\bigstar}★ \large\boxed{\tt\purple{y = 7}}

y=7

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• Given:-

x + y = 18

x - y = 4

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• To Find:-

Value of x and y.

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• Solution:-

✴ \sf x + y = 18 \dashrightarrow\bf\red{[eqn.i]}x+y=18⇢[eqn.i]

✴ \sf x - y = 4 \dashrightarrow\bf\red{[eqn.ii]}x−y=4⇢[eqn.ii]

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• Taking eqn.[i]:-

➪ \sf x + y = 18x+y=18

➪ \sf x = 18 - y \dashrightarrow\bf\red{[eqn.iii]}x=18−y⇢[eqn.iii]

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• Substituting eqn.[iii] in eqn.[ii]:-

➪ \sf x - y = 4x−y=4

➪ \sf (18-y) - y = 4(18−y)−y=4

➪ \sf 18 - y - y = 418−y−y=4

➪ \sf 18 - 2y = 418−2y=4

➪ \sf - 2y = 4 - 18−2y=4−18

➪ \sf - 2y = - 14−2y=−14

➪ \sf y = \dfrac{-14}{-2}y=

−2

−14

★ \large{\bf\pink{y = 7}}y=7

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

• Substituting value of y in eqn.[i]:-

➪ \sf x + y = 18x+y=18

➪ \sf x + 7 = 18x+7=18

➪ \sf x = 18 - 7x=18−7

★ \large{\bf\pink{x = 11}}x=11

⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀

Therefore, value of x = 11 and y = 7.

Answer 2

$\small\mathbf\orange{{Relative \: Referencing }}$

When copied across multiple cells, they change based on the relative position of rows and columns.

For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.