Inicio
/
Tecnología
/
Which Function Adds a Range of Cells? =Max Min Average Sum

Problemas

Which function adds a range of cells? =Max Min Average Sum

Roztwór

Esther élite · Tutor durante 8 años
Weryfikacja ekspertów
4.2 (265 Votos)

Respuesta

The function that adds a range of cells in Excel is the SUM function. The syntax for the SUM function is:SUM(number1, [number2],...)Where:- number1 is the first number or range of numbers that you want to add.- number2 is an optional additional number or range of numbers that you want to add.For example, if you want to add the values in cells A1 through A10, you would use the formula:=SUM(A1:A10)The other functions mentioned in the question have different purposes:- MAX returns the largest value in a set of values.- MIN returns the smallest value in a set of values.- AVERAGE calculates the average of a set of values.So, the correct answer is: Sum