Question

What is the use of autosum function

Answer 1

Answer:

When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here's an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum.

Answer 2

Explanation:

AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. For example, if you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (shown right). Clicking this button after highlighting the cells creates the formula =SUM(A1:A5) in cell A6 (first cell after last highlighted cell) and gives you the total of all those cells.