An assignment was given to Sanjiv and Vibha by their teacher. They were shown the screen shot given below and were asked to answer the following questions:

(i) What happens when the formula = B2 + C2 is entered in D2?

(ii) What happens when the formula of D2 is copied over to D6?

(iii) What will happen if we modify the formula in the cell D6 to = $\text{\textdollar B}6 + \text{\textdollar C}6$?

(iv) What happens when we copy the formula of D6 to D3?

(v) If we delete the value of C3, what will be the new value of D3?

(i) D2 will display the sum of the values in cells B2 and C2.

D2 = B2 + C2
D2 = 130 + 2300
D2 = 2430

(ii) When the formula in D2 is copied over to D6, the relative references in the formula (B2 and C2) will adjust based on the relative position. So, the formula will be modified as = B6 + C6. Thus, D6 will display the sum of the values in cells B6 and C6.

D6 = B6 + C6
D6 = 295 + 3040
D6 = 3335

(iii) The dollar signs $(\text{\textdollar})$ indicate absolute references, meaning that the column (B and C) will remain fixed when the formula is copied or filled to other cells horizontally. The row (6) will still adjust based on the relative position.

(iv) When the formula in D6 is copied to D3, The absolute references (B and C) will remain fixed and only row (6) will adjust according to the relative position.

Thus, the formula in D3 will be $=\text{\textdollar B}3 + \text{\textdollar C}3$, reflecting the change in the row number while keeping the column references fixed.

D3 = $\text{\textdollar B}3 + \text{\textdollar C}3$
D3 = 490 + 2190
D3 = 2680

(v) If the value of C3 is deleted, the new value of D3 will be the sum of the remaining values in B3 and C3 (now treated as 0).

D3 = $\text{\textdollar B}3 + \text{\textdollar C}3$
D3 = 490 + 0
D3 = 490