Question

Which function adds values in Excel

• A. SUM
• B. AVG
• C. ADD
• D. TOTAL

Answer 1

Answer:

A. SUM

The primary function used to add values in Excel is SUM.

While you can use the plus sign ($+$) for basic addition, the SUM function is the "heavy lifter" designed to handle large ranges of cells efficiently.

1. The SUM Function

This is the most common way to add up numbers. You can select individual cells, a continuous range, or even multiple separate ranges.