Excel Problem: Post-Closing Trial Balance 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 I. DATA Account Cash Accounts Receivable Accounts Payable Equipment Unearned Revenue Accumulated Depreciation Balance 2,000 900 380 700 Account Prepaid Rent Notes Payable Retained Earnings Common Stock Account X Balance 400 250 660 540 ??? 70 200 II. Post-Closing Trial Balance 3 Debit Credit 5 3 0 Cash Accounts Receivable Prepaid Rent Equipment Accumulated Depreciation Unearned Revenue Accounts Payable Notes Payable Retained Earnings Common Stock Account X TOTALS: 1 2 3 5 16 37 39 40