What is the formula equivalent of the function =sum(b1: b5)?

=b1+b5

=$b$1+$b$5

=b1+b2+b3+b4+b5

=$b$1+$b$2+$b$3+$b$4+$b$5

=$b1+$b2+$b3+$b4+$b5

=B1+B2+B3+B4+B5

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

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.