Answered step by step
Verified Expert Solution
Question
1 Approved Answer
16 Payroll Tax Expense 19 Rent Expense 20 Miscellaneous Expense 21 Insurance Expense 22 utilities Expense 23 Total 2900 8400 3900 2400 3500 . To
16 Payroll Tax Expense 19 Rent Expense 20 Miscellaneous Expense 21 Insurance Expense 22 utilities Expense 23 Total 2900 8400 3900 2400 3500 . To get the value of cell B23, you may use the AutoSum Function or Formula.(Please take note that total of both cells B23 and C23 should be equal. Save the worksheet in your devices / laptop, name it Cruz Specialty Foods Trial Balance as a filename. Upload the excel file in our online classroom. Page 7 / 10 @ + : module 4 gle.com NGWE IMELLEENTE Activity 2. Create another new Excel worksheet Type the type following data. Credit I A B 1 CRUZ SPECIALTY FOODS 2 TRIAL BALANCE 3 3 December 31, 2004 4 5 Debit 6 Cash 18500 7 Accounts Receibable, 12/31/04 4500 8 Inventory, 12/31/04 20000 9 Equipment 35000 10 Accumulated Depreciation 12/31/04 11 Accounts Payable, 12/31/04 12 Payroll Taxes Withheld 13 Juan Cruz, Capital, 12/31/04 14 Juan Cruz Drawings 24000 15 Sales Revenue 16 Purchases 82700 12S 1 Salaries Expense 29500 18 Payroll Tax Expense 2900 19 Rent Expense 8400 20 Miscellaneous Expense 3900 21 Insurance Expense 2400 22 utilities Expense 3500 23 Total 9000 4800 850 33650 187000 To get the value of cell 823, you may use the AutoSum Function or Formula.(Please take note that total of both cells 823 and 23 should be equal
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started