What would be the resultant value after executing the function =-SUM(C2:C3) as…

2018

What would be the resultant value after executing the function =-SUM(C2:C3) as shown in the following figure?

image.png

  1. A.

    1234

  2. B.

    2469

  3. C.

    Invalid

  4. D.

    -2469

Attempted by 35 students.

Show answer & explanation

Correct answer: D

Looking at the question, we have values in column C:

  • Cell C2 = 1234

  • Cell C3 = 1235

The formula entered in cell C4 is: = -SUM(C2:C3)

  1. First, the SUM(C2:C3) function calculates the total of the cells from C2 to C3:

    1234 + 1235 = 2469

  2. Second, the minus sign (-) preceding the function acts as a unary negation operator, multiplying the result by -1:

    - (2469) = -2469

Therefore, the final output displayed in cell C4 will be -2469.

Explore the full course: Btsc Lab Assistant