Please see attached.

Open the Excel file.

Answerthe questions on the file and save as excel file.

Test 2 Chapters 3, 4 and 5 Complete this part of the test and place in the drop box by the due date. Complete this worksheet with the information given below. Then complete a balance sheet. Be sure to Total each column!! . The Adjustments are written below the worksheet. You might want to journalize out on a sheet of paper the adjustments before typing them in the worksheet. Cash AR Supplies Equipment Accum depreciation Automobile Accum depreciation AP Wages Payable Unearned Fees Jones, Capital Jones, Drawing Fees Earned Rent Expense Wages Expense Utility Expense Supplies Expense Depreciation Expense Misc. Expense Total Trial Balance DR CR 10,000 2,000 1,000 5,000 2,000 15,000 3,000 5,000 2,000 3,000 10,700 1,000 12,000 2,000 1,000 500 200 37,700 37,700 Adjustments DR CR Adj. Trial Balance DR CR Income Statement DR CR Balance Sheet DR CR The following adjustments have accured. Place these on your worksheet. If the account is not currently there, add it to the bottom. 1. Used $500 of supplies. 2. Earned $5,000 of fees this period, but have not been billed yet 3. Depreciation expense on the equipment is period is $300 4. Wages earned but not paid yet, $2000 5. Earned $1000 of the unearned fees Complete the Balance sheet. Be sure to place dollar signs and commas where needed (there is a dollar sign and comma sign on your format tool bar) I have included the ending capital. SHOW BOOKVALUE IN MIDDLE COLUMN FOR PLANT ASSETS (SEE THE SAMPLE BALANCE SHEET IN CHAPTER 4 NOTES) Balance Sheet Assets: Current Assets Total Current Assets Prop. Plant and Equip. Total Prop. Plant & Equip. Total Assets Liabilities Current Liabilites Total Liabilities Owner's Equity Jones, Capital Total Liab. And O.E. 21,200 You have completed the test. Please go to file and save as and then submit the test in the assignments drop box