Question

which of the following functions returns the total of all values in a range of cells?
○ total
○ sum
○ average
○ add

Explanation:

In spreadsheet software (like Excel), the SUM function is used to calculate the total (sum) of all values in a specified range of cells. The TOTAL function is not a standard function for this purpose, AVERAGE calculates the mean, and ADD is not the standard function for summing a range.

Answer:

B. SUM