I need this for a job. How would I enter this information into an excel worksheet?

On July 12th 2014 one of our Client's cash book showed a debit balance of $4,000.00. His bank

statement showed a balance of $4,270.00.

On comparison the following were found:

Check issued amounting to $2,500.00 has not been cashed.

The bank rejected checks amounting to $140.

Standing order for a staples order of $700 was noted.

A customer paid $170 directly into the bank without any notice to our company

Bank charges of $160 were entered in the bank statements only.

A dividend of $250 was paid directly into the bank and not recorded in the cash book

Checks for $1,650.00 was entered into the cash book and deposited in the bank but

had not been cleared (deposited).

You are required to prepare:

Bank reconciliation statement for the month.

Balance per bank statement (Add) Uncredited checks, standing order, bank charges

and dishonored checks. (Less) Unpresented checks, dividend, credit transfer.

Balance per cash book

Have them Submitted in MS Excel Spread Sheet