Question

3) Write note on Fill feature of Ms Exce
i
​

Answer 1

AutoFill Formulas

Click and hold on the fill handle and drag to the right (or down) to fill in the other cells. Excel automatically adjusts the formula for the row it is now on (so, in the example at right, February's total formula would read =SUM(B3:F3) and so on.

Answer 2

Click and hold on the fill handle and drag to the right (or down) to fill in the other cells. Excel automatically adjusts the formula for the row it is now on (so, in the example at right, February's total formula would read =SUM(B3:F3) and so on