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?

- A.
1234
- B.
2469
- C.
Invalid
- 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)
First, the
SUM(C2:C3)function calculates the total of the cells from C2 to C3:1234 + 1235 = 2469
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.