please do it on excel

ABC Company had the following adjusted trial balance. ABC COMPANY Adjusted Trial Balance for the Month Ended June 30, 2017 Adjusted Trial Balance Account Titles Debits Credits Cash $1,856 Accounts Receivable 1,952 Supplies 240 Accounts Payable $ 691 Unearned Service Revenue 80 Owner's Capital 2,880 Owner's Drawings Service Revenue Salaries and Wages Expense 630 Miscellaneous Expense Supplies Expense Salaries and Wages Payable 230 $6,031 $6,031 2,150 Instructions (a) Prepare closing entries at June 30, 2017. (b) Prepare a post-closing trial balance