need help with formulas

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. DATA 13 Cash Account Accounts Receivable Accounts Payable Equipment Unearned Revenue Balance Account Balance 2,200 Prepaid Rent 400 900 Notes Payable 250 16 480 Retained Earnings 660 18 700 Common Stock 600 Accumulated Depreciation 190 Account X 12. I. DATA 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. DATA 13 Cash Account Accounts Receivable Accounts Payable Equipment Unearned Revenue Balance Account Balance 2,200 Prepaid Rent 400 900 Notes Payable 250 16 480 Retained Earnings 660 18 700 Common Stock 600 Accumulated Depreciation 190 Account X 12. I. DATA