Question

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

1) =b1 b5
2) =$b$1 $b$5
3) =b1 b2 b3 b4 b5
4) =$b$1 $b$2 $b$3 $b$4 $b$5
5) =$b1 $b2 $b3 $b4 $b5

Answer 1

The formula equivalent of the function =SUM(B1:B5) is =$B$1 $B$2 $B$3 $B$4 $B$5.

Step-by-step explanation:

The formula equivalent of the function =SUM(B1:B5) is option 4) =$B$1 $B$2 $B$3 $B$4 $B$5.

This formula sums the values in the range B1 to B5, inclusive.

The dollar sign ($) before the column letter and row number indicates an absolute reference, meaning that the cell reference will not change when the formula is copied to other cells.