Bank Statement 18 19 20 21 22 23 24 25 26 27 28 29 Statement date 5/17/17 Date 4/17/17 4/19/17 4/20/17 4/23/17 4/24/17 4/26/17 5/2/17 5/4/17 5/4/17 5/8/17 5/12/17 5/13/17 5/15/17 5/16/17 5/17/17 . Description Rent Utilities Paycheck Groceries New clothes Return shirt Cell phone bill Pizza Paycheck Withdraw cash Check # 278 Groceries Gas Netflix streaming fee Interest Previous balance $2,358.25 11 debits 4 credits Statement balance Debits ($400.00) ($120.39) ($79.24) ($93.18) ($78.44) ($11.02) ($200.00) ($40.00) ($48.23) ($38.68) ($11.99) Credits $620.34 $22.01 $572.29 Balance $1,958.25 $1,837.86 $2,458.20 $2,378.96 $2,285.78 $2,307.79 $2,229.35 $2,218.33 $2,790.62 $2,590.62 $2,550.62 $2,502.39 $2,463.71 $2,451.72 $0.56 $2,452.28 Write a formula for cell F4 to add all of the debits. Write a formula for cell F5 to add all of the credits. Write a formula for cell F6 to compute the Statement balance after all of the credits and debits have been included.

Bank Statement \begin{tabular}{lr|r|} Statement date & Previous balance $2,358.25 \\ 5/17/17 & 11 debits & \\ \hline \end{tabular} Write a formula for cell F4 to add all of the debits Write a formuls for celi rs to add all of the credits. Write a formula for cell F6 to compute the Statement balance after all of the creditr and debits have been included