Acct excel problems

profilegymjunky
stice19_student_02-35.xlsx
Home>Business & Finance homework help>Accounting homework help>Acct excel problems

02-35

02-35 Name:
Complete columns D, F, H, J, and L by selecting the correct answer from the drop-down list in the blue-shaded cells. If you select
an incorrect answer, the word "Wrong" will appear to the left of the answer cell.
Account Title (1) B/S I/S N (2) A, L, OE, R, E, O (3) Real or Nominal (4) Closed or Open (5) Debit (Dr.) or Credit (Cr.)
(a) Unearned Rent Revenue B/S
(b) Accounts Receivable I/S
(c) Inventory N
(d) Accounts Payable
(e) Prepaid Rent A
(f) Mortgage Payable L
(g) Sales OE
(h) Cost of Goods Sold R
(i) Dividends E
(j) Dividends Payable O
(k) Interest Receivable
(l) Wages Expense Real
(m) Interest Revenue Nominal
(n) Supplies
(o) Accumulated Depreciation Closed
(p) Retained Earnings Open
(q) Discount on Bonds Payable
(r) Goodwill Dr.
(s) Additional Paid-In Capital Cr.

Solution

02-35 Name: Solution
Complete columns D, F, H, J, and L by selecting the correct answer from the drop-down list in the blue-shaded cells. If you select
an incorrect answer, the word "Wrong" will appear to the left of the answer cell.
Account Title (1) B/S I/S N (2) A, L, OE, R, E, O (3) Real or Nominal (4) Closed or Open (5) Debit (Dr.) or Credit (Cr.)
(a) Unearned Rent Revenue B/S L Real Open Cr. B/S
(b) Accounts Receivable B/S A Real Open Dr. I/S
(c) Inventory B/S A Real Open Dr. N
(d) Accounts Payable B/S L Real Open Cr.
(e) Prepaid Rent B/S A Real Open Dr. A
(f) Mortgage Payable B/S L Real Open Cr. L
(g) Sales I/S R Nominal Closed Cr. OE
(h) Cost of Goods Sold I/S E Nominal Closed Dr. R
(i) Dividends N O Nominal Closed Dr. E
(j) Dividends Payable B/S L Real Open Cr. O
(k) Interest Receivable B/S A Real Open Dr.
(l) Wages Expense I/S E Nominal Closed Dr. Real
(m) Interest Revenue I/S R Nominal Closed Cr. Nominal
(n) Supplies B/S A Real Open Dr.
(o) Accumulated Depreciation B/S A Real Open Cr. Closed
(p) Retained Earnings B/S OE Real Open Cr. Open
(q) Discount on Bonds Payable B/S L Real Open Dr.
(r) Goodwill B/S A Real Open Dr. Dr.
(s) Additional Paid-In Capital B/S OE Real Open Cr. Cr.