please explain with excel numbers

The June bank statement and the cash T$-$account for Superior Printing Company is shown below.

Date

June $1$

$3$

$4$

$8$

$10$

$13$

$20$

$22$

$26$

$27$

$29$

$30$

BANK STATEMENT

Checks

Deposits

June $1$ Bal.

June $13$ deposit

June $22$ deposit

June $29$ deposit

June $30$ deposit

$440$

$1,200$

$500$

$1,200$

$250$

$80$

$9,800$

$350$

$4,600$

$700$

$920$

$600$

Other

Cash

$18,500|$

$10,000$

$35,000|$

$17,000$

$28,000$

$10,000$

$35,000$

NSF

$17,000$

Serv. Charge Interest Earned

$840$

$50$

$30$

Balance

$18,500$

$18,060$

$16,860$

$16,360$

$15,160$

$24,910$

$23,990$

$49,190$

$48,840$

$44,240$

$60,540$

$59,570$

$59,000$

$440$ Check #$100$

$1,200$ Check #$101$

$500$ Check #$102$

$1,200$ Check #$103$

$250$ Check #$104$

$80$

Check #$105$

$9,800$

Check #$106$

$350$ Check #$107$

$4,600$ Check #$108$

$770$ Check #$109$

$4,900$ Check #$110$

$700$ Check #$111$

$920$ Check #$112$

$600$ Check #$113$

June $30$ Bal.

$82,190$

Required:

Prepare a bank reconciliation for June using the bank statement and T$-$account above and the information below.

Additional information:

There were no deposits in transit or outstanding checks at May $31.$

$($Use cells A$4$ to F$36$ from the given information to complete this question. All answers should be input and displayed as positive values.$)$

SUPERIOR PRINTING COMPANY

Bank Reconciliation

At June $30$

Bank Statement

Updates to Company's Books

Bank statement balance

Additions:

Book balance

Additions:

Deposits in Transit

Interest Earned

Deductions:

Deductions:

Outstanding Checks

Adjusted bank balance

NSF Check

Service Charge