JA A B C D E F G H 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 I. DATA Account Balance Cash 2,000 Accounts Receivable 900 Accounts Payable 380 Equipment 700 Unearned Revenue 70 Accumulated Depreciatior 200 Account Prepaid Rent Notes Payable Retained Earnings Common Stock Account X Balance 400 250 660 540 ??? II. Post-Closing Trial Balance Credit 5 Cash Accounts Receivable Prepaid Rent Debit 2,000 900 400