please include cell references thank you!

Excel Problem: Post-Closing Trial Balance Name: Using cell addresses, properly place each account's balance in either the debit column or the credit column, assuming each account has a normal balance. Input a simple formula to determine the credit balance of "Account X" that will correctly complete the trial balance. Use the SUM function to produce the total for each column + Submit in Black Board 1 2 I. DATA 3 Account Balance Account Cash 2,000 Prepaid Rent 5 Accounts Receivable 900 Notes Payable 6 Accounts Payable 380 Retained Earnings Equipment 700 Common Stock 8 Unearned Revenue 70 Account X Accumulated Depreciation 200 4 Balance 400 250 660 540 ??? 7 9 0 1 II. Post-Closing Trial Balance Debit Credit 2 23 24 25 26 27 28 29 30 Cash Accounts Receivable Prepaid Rent Equipment Accumulated Depreciation Unearned Revenue Accounts Payable Notes Payable Retained Earnings Common Stock Account X TOTALS: 31 32 33 34 35 36 32 38 39 40 41