What will be the output of =SUM(C2:C8) in MS Excel?
A
Displays the sum of cells C2 through C8 that contain numbers.
B
Count the number of cells
C
Displays the sum of cells C1 through C7 that contain numbers.
D
NULL appears in the respective cell.
Correct Option:
A
Explanation
The formula =SUM(C2:C8) adds the numeric values in the continuous range from C2 to C8, inclusive. Text and blank cells in the range are ignored rather than causing the formula to fail.
