Which function would you use to sum a range of cells in Excel?

The function used to sum a range of cells in Excel is indeed SUM. This function allows users to add together all the numerical values within a specified range, providing a quick and efficient way to calculate totals. The syntax for using the SUM function is straightforward: you simply specify the range of cells you want to sum, for example, =SUM(A1:A10), which would total all values from cells A1 to A10.

Using the SUM function is an essential part of working with spreadsheets, especially for tasks that involve financial data, inventory, or any situation where aggregation of numerical data is necessary. This function is versatile and can handle individual cells, entire rows or columns, and multiple ranges, making it a fundamental tool in Excel for data analysis and manipulation.