Anip has written the formula=$A $5+A1+B1 in the cell c1.1.what will be

1.	Anip has written the formula=$A $5+A1+B1 in the cell c1.1.what will be the value in c1 2. what will be the value in c2:C4 if anup dragged the fill handle from c1 to c4? 3. what types of referencing are $A $5 and a1+b1?please answer my question i will mark you the brainliest....
Answer» 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 helped you

Anip has written the formula=$A $5+A1+B1 in the cell c1.1.what will be the value in c1 2. what will be the value in c2:C4 if anup dragged the fill handle from c1 to c4? 3. what types of referencing are $A $5 and a1+b1?please answer my question i will mark you the brainliest....

Answer»

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 helped you