Respuesta :

wiseowl2018

Answer:

=B1+B2+B3+B4+B5

Explanation:

The SUM function in Microsoft Excel is used to add two or more than two cells. The SUM function, one of the math and trig functions, adds values. We can add individual values, cell references or ranges or a mix of all three. The syntax is SUM(number1,[number2],...). Since the given function is showing SUM(B1:B5) so it means that add the cells from cell B1 to B5. So we can write as B1+B2+B3+B4+B5

fichoh

The excel function given above is used to apply a particular function cells within a certain range. Hence, the formular equivalent to the function is =B1+B2+B3+B4+B5

The lower and upper boundary of the range is stated and seperated using the ratio(:) sign. This means that all cells which falls inbetween and including the boundaries are passed into the stated function.

The function does not include the $ sign as it is relative and not an absolute formula.

Hence, the equivalent formula is =B1+B2+B3+B4+B5

Learn more : https://brainly.com/question/13101220

Otras preguntas

Q&A Education