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