A Excel Problem: Post-Closing Trial Balance 1 2 3 Name: 6 5 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. 7 Input a simple formula to determine the credit balance of Account X" that 8 will correctly complete the trial balance. 9 Use the SUM function to produce the total for each column. 10 Submit in Black Board 11 12 I. DATA 13 Account Balance Account Balance Cash 2,000 Prepaid Rent 400 Accounts Receivable 900 Notes Payable 250 16 Accounts Payable 380 Retained Earnings 660 17 Equipment 700 Common Stock 540 Unearned Revenue 70 Account X ??? Sheet1 Sheet2 Sheet3 + 14 15 18 a e > Type here to search 8 hp C2 x D E F G H 13 Balance 14 400 250 660 15 Account Prepaid Rent Notes Payable Retained Earnings Common Stock Account X B 12 I. DATA Account Balance Cash 2,000 Accounts Receivable 900 Accounts Payable 380 Equipment 700 18 Unearned Revenue 70 19 Accumulated Depreciatior 200 20 21 II. Post-Closing Trial Balance 22 16 17 540 ??? 23 24 Credit 25 26 27 Debit Cash Accounts Receivable Prepaid Rent Equipment Accumulated Depreciation Sheet1 Sheet2 Sheet 28 29 Type here to search a (hp) D B 21 II. Post-Closing Trial Balance 2 93 Debit Credit 25 26 27 28 09 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 37 38 Sheet1 Sheet2 Sheet3 a o O Type here to search HI