Question

What is the purpose of the AutoSum feature in Microsoft® Excel? A. To automatically add all numbers in all cells in a workbook B. To add a list of numbers in a spreadsheet C. To put a list of numbers in order before finding the sum D. To estimate the total of a list of numbers

Answer 1

B. To add a list of numbers in a spreadsheet

Explanation:

AutoSum feature in Microsoft Excel is used to automatically sum up a range of numbers within a horizontal row or vertical column without having to input a formula.

When a range of numbers are selected within a row or column, clicking on AutoSum will sum up the numbers in the adjacent empty cell. For example, if you wanted to add the values of cells between B1 and B10, highlight cells B1 through B10 and click the AutoSum button . The sum of B1 to B10 will be given in B11.

In Excel 2010 and later, the AutoSum feature is on the Home tab, in the Editing section.