Question

which formula is the same as the function =sum(b1:b5)?
a. =b1+b5
b. =$b$1+$b$5
c. =b1+b2+b3+b4+b5
d. =$b$1+$b$2+$b$3+$b$4+$b$5
e. =$b1+$b2+$b3+$b4+$b5

Explanation:

Step1: Understand SUM function

The SUM function \(=\text{SUM}(B1:B5)\) sums cells from B1 to B5.

Step2: Analyze each option

• Option A: \(=B1 + B5\) sums only two cells.
• Option B: \(=\$B\$1+\$B\$5\) sums two fixed - position cells.
• Option C: \(=B1 + B2 + B3 + B4 + B5\) sums all cells from B1 to B5, same as \(=\text{SUM}(B1:B5)\).
• Option D: \(=\$B\$1+\$B\$2+\$B\$3+\$B\$4+\$B\$5\) uses absolute references.
• Option E: \(=\$B1+\$B2+\$B3+\$B4+\$B5\) has mixed references.

Answer:

C. =B1+B2+B3+B4+B5