Question

what will happen if we modify the formula in the cell D6to=$B6+$C6 in excel 2010​

Answer 1

For example, when you copy the formula in cell B6 to C6, the formula in that cell automatically changes to update to cell references in column C. When you copy the formula, ensure that the cell references are correct. Cell references may change if they have relative references.