Which function is used to add a range of cells?

The method to add a range of cells in a spreadsheet is accomplished using the SUM function. This function computes the total of all numeric values within a specified range of cells.

For example, if you have a range such as A1 to A10 with values, using the formula =SUM(A1:A10) will yield the total of those numbers. This is essential for tasks involving calculations of totals, financial analyses, or any situation where summation of data is required.

While AVERAGE calculates the mean of the numbers in a defined range, ADD and TOTAL do not correspond to any standard functions within spreadsheet applications such as Excel or Google Sheets. Therefore, the SUM function is specifically designed for the purpose of adding together a specified collection of cell values, making it the correct and most suitable choice for this task.