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

Multiple Choice

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

$$ The formula in cell C$10$ should be $\frac{?}{S}=UM(B22B10)-$SUM$($C$2$:C$10)$

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

$$ The formula in cell B$10$ should be $=$ SUM $(B2$:$B9)+$ SUM $(C2$:$C9)$