Question

Which of the following formulas is equivalent to =SUM(A1:A3)?

OA. =A3-A1
OB. =A1+A3
OC. =A1+A2+A3
OD. =A2

Answer 1

The correct formula that is equivalent to =SUM(A1:A3) is: C. =A1+A2+A3.

The formula =SUM(A1:A3) calculates the sum of the values in cells A1, A2, and A3.

Let's analyze the other options:

A. =A3-A1: This formula subtracts the value in cell A1 from the value in cell A3. It does not consider the value in cell A2.

B. =A1+A3: This formula adds the values in cell A1 and A3. It does not consider the value in cell A2.

C. =A1+A2+A3: This formula adds the values in all three cells (A1, A2, A3), which matches the functionality of =SUM(A1:A3).

D. =A2: This formula simply returns the value in cell A2, ignoring the other cells.

Therefore, the only option equivalent to =SUM(A1:A3) is OC. =A1+A2+A3.