https://1drv.ms/x/s!Ajz1egTFoa8gcuoTSY77n4NOPPw?e=bcNvmP

Scenario: Company A began business operations this year. The company performs repair and upgrade jobs on heavy machinery for its customers. The company uses the following accounts to record revenue transactions: Cash, Accounts Receivable, Unearned Fees, and Fees Earned. The company records three types of revenue transactions, named and explained as follows: Earned revenue Started and completed a job for a cash customer this year Deferred revenue Received cash in advance from a customer for a job to be completed over time Accrued revenue Began a job for a customer that will be completed next year; the customer will pay in full when job is finished All completed jobs have been paid in full by the customer. The Data worksheet contains a list of revenue transactions classified by type. There are three types of revenue transactions shown in the Transaction Type column: earned revenue, deferred revenue, and accrued revenue. The Job Amount When Complete column lists the full amount of each job from start to finish. The Job Amount To Date column lists the amount of each job that has been finished so far by the end of the year. Required: X Open spreadsheet Complete one column on the Data worksheet: Remaining Job Amount. Use this information to complete the requirements below. R1. Cell F2: Use a formula referring to other amounts in the row to calculate the remaining amount to still be completed on the job. R2. Copy down the entry in cell F2 to all the other rows with data. Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert / PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. $4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions:Q1. What is the total amount in the Fees Earned account for the year after adjusting entries have been recorded? 5 U Q2. What is the balance in the Accounts Receivable account at the end of the year after adjusting entries have been recorded? 5 U Q3. What is the balance in the Unearned Fees account at the end of the year after adjusting entries have been recorded? 5 U Q4. E-y what amount would total Fees Earned have been understated if adjusting entries had been omitted in error? E U Q5. What are the two possible accounts that Company A might debit for adjusting entries for revenue earned during the year? Cash and Accounts Receivable Accounts Receivable and Unearned Fees Accounts Receivable and Fees Earned O C} C} O Unearned Fees and Fees Earned