Question

2. Explain the different methods of calculating the sum of a range of cells.
3. What happens if we make the corrections in the data after typing formula? Do wen
the formula again? Explain.​

Answer 1

Answer:

2.We can use the Excel AutoSum feature, select the cells you want to sum and click on the AutoSum button given on the Home Tab, When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. ... You can Manually write the Formula.

3. When you set the cell formatting to "Text", Excel treats the formula as text and shows it instead if evaluating it. To fix this error, just select the cell, set it's formatting to "General". Now edit the formula and press enter.