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

Correct option is D

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

1. The SUM(C2:C3) part adds the values in cells C2 and C3:

1234+1235=2469

2. The minus sign before the SUM makes the result negative:

=-2469

So, the resultant value displayed in C4 will be -2469.

Important Key Points:

1. SUM(range) adds all numeric values within the specified range of cells.
2. A negative sign (-) placed before a function negates the final result.
3. Excel evaluates functions using standard arithmetic rules — operator before function applies after function's result.

Knowledge Booster:

• 1234: This is just the first cell’s value (C2). The formula doesn’t extract a single value; it sums the range.
• 2469: This is the correct sum of 1234 + 1235, but since the formula has a leading minus sign, this positive value is not the final result.
• Invalid: The formula is syntactically and logically correct, so no error or invalid output occurs.