Which sequence correctly uses AutoSum to total the contiguous cells above the active cell?

Which sequence correctly uses AutoSum to total the contiguous cells above the active cell?

• A. In the Home tab, Editing group, click AutoSum button arrow; in the AutoSum menu, click Sum; press Enter.
• B. Use the Formulas tab, click AutoSum, select Average; press Enter.
• C. Use the Data tab, click Sum; press Enter.
• D. Right-click the selected cell, choose Sum; press Enter.

Answer: (A)

AutoSum quickly totals the numbers directly above the active cell by inserting a sum formula for that vertical block. The correct sequence uses the AutoSum control in the Home tab, Editing group: click the AutoSum button arrow to open the menu, choose Sum, then press Enter. Excel automatically selects the contiguous cells above the active cell in that column and inserts the appropriate SUM formula. This path is the standard, direct way to apply AutoSum; other tabs or context-menu options either perform different functions or don’t use the AutoSum shortcut for this specific action.

AutoSum quickly totals the numbers directly above the active cell by inserting a sum formula for that vertical block. The correct sequence uses the AutoSum control in the Home tab, Editing group: click the AutoSum button arrow to open the menu, choose Sum, then press Enter. Excel automatically selects the contiguous cells above the active cell in that column and inserts the appropriate SUM formula. This path is the standard, direct way to apply AutoSum; other tabs or context-menu options either perform different functions or don’t use the AutoSum shortcut for this specific action.