Applying Excel $2$: Computing the ending balance in a T$-$account $-$ REVENUES

Assuming a revenue has a normal ending balance, select the correct cell location and formula for its ending balance.

Multiple Choice

The formula in cell B$6$ should be $=$SUM$($C$2$:C$6)-$SUM$($B$2$:B$6)$

The formula in cell C$6$ should be $=$ SUM$($C$2$:C$6)-$SUM$($B$2-$B$6)$

The formula in cell C$6$ should be $=$ SUM$($B$2$:B$5)-$SUM$($C$2$:C$5)$

The formula in cell C$6$ should be $=$ SUM $(C2$:$C5)-$SUM $(B2$:$B5)$