Question

Anup has written the formula = $A$5+A1+B1 in the cell C1
What will the value of C1

Answer 1

Answer:

1. c1 =$A $5+A1+B1

C1 will have this as value

2. If anup drag the value of C1 till C4, then value of c2, c3 and c4 will be this

C2=$A $5+A2+B2

C3=$A $5+A3+B3

C4==$A $5+A4+B4

3. $A $5 this is called absolute reference and a1+b1 is called relative reference.

I hope this helps you pls mark as branliest