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 option 4) =$$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.

Each cell in a spreadsheet is identified by a column letter and a row number. The dollar sign in the formula indicates an absolute reference, meaning that the column and row references will not change when the formula is copied or moved.

In the given function, b1:b5 represents a range of cells from cell b1 to b5, so the formula =$b$1 $b$2 $b$3 $b$4 $b$5 means that it will sum the values in cells b1 to b5.