answers must use excel formulas

The June bank statement and the cash T-account for Superior Printing Company is shown below. Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. Additional information: Additional information: There were no deposits in transit or outstanding checks at May 31 . (Use cells A4 to F36 from the given information to complete this question. All answers should be input andi cisplayed as positive values.)