Pag question Question 1 Not yet answered Marked out of 100.00 Answer the following problem by completing and totaling up a properly constructed ten-column worksheet. Use one the following methods: 1. The best, most efficient way to complete the test is to use the Excel Template File that appears directly under this test link on the Moodle page. You can fill this in with the answers to all problems and then just submit the completed Excel file. OR 2. Use the ten-column worksheet found as an available print-out template on this Chapter 4 page, take photos when complte (2 should cover the three problems) and submit as a files here. OR 3. If you're handy with either Word (using tables) or Excel (Spreadsheet) you can create your own documents that shows a completed ten-column worksheet, which you can just name and send in. If you cannot set up columns/tables in a fashion that's readable, use one of the first two methods please. If you have any difficulty with any of these approaches, call me at 252- 531-0441 and we'll figure out what to do next. Problem 1: Following is the Unadjusted Trial Balance of Ocelot Company, a private corporation owned and operated by Olivia Ocelot. All day-to-day transactions have already been recorded through December 31, 2021. All the balances shown are up to date, but unadjusted. Ocelot Company Unadjusted Trial Balance December 31, 2021 Credit Debit $ 19,500 3,700 1,200 27,000 Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation- Equipment Accounts Payable Common Stock Retained Earnings Dividends Service Revenue Salary Expense Utility Expense Miscellaneous Expense Totals $ 4,800 9,100 14,000 8,900 2,500 48,900 24,200 6,500 1,100 $ 85.700 $ 85.700 Adjustment Data: Adjustment Data: a) A $1,500, unbilled, unrecorded invoice for services already performed December 6 th, by Ms. Ocelot for a client was found and mailed out to the customer. b) Depreciation on equipment this year is $750. c) Accrued salaries for the last few days of work in 2021 are $850. d) $400 worth of insurance has expired. Required: Record and complete the above information in a properly constructed 10-columnworksheet. [Three add- on accounts are needed.] Problem 2: Using the completed worksheet from Problem , produce the closing entries in journal form. (2 entries in all) Problem 3: Produce the Post Closing Trial Balance for Ocelot Company for December 31, 2021