Question

Which function automatically totals a column or row of values?

Options

• TOTAL

• ADD

• SUM

• AVG

Answer 1

SUM

Explanation:

In Microsoft Excel, the SUM function is the official built-in formula used to automatically add up a row or column of numbers. Functions like TOTAL or ADD do not exist in Excel, and AVG is used only to find averages. By using = SUM(A1:A10), you can instantly calculate the total of multiple cells without manual addition.