unction: SUM; Formula: Add, Subtract; Cell Referencing

Jsing Excel to Prepare a Bank Reconciliation

PROBLEM

$\text{'}$he following information relates to Kemick Company's cash account or the month of August.

Unadjusted cash balance, August $31$

Bank statement balance, August $31$

Outstanding chedues

Denosit in transit

NSF cheaue

Interest earned

Bank service charge

$ $10,050$

$8\mathrm{.}370$

$1,623$

$3\mathrm{.}005$

$280$

$27$

$40$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work area as indicated. Use the SUM function with cell referencing to add amounts.

Prebare a bank reconciliation at August $31.$

Add:

Less:

Add:

Less: Service charge