Excel nnohi1 - Saved Search (Alt + Q ) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Times New Ro... V 12 BFV Av ... Ev ab Merge Number - $ v H6 1 Question 1: Pivot Table (4 BONUS marks) Lome Dach Consulting had the following transactions for the month of June. The accountant has completed all of the transaction analysis (see tab) Required: (a) What is the total assets on June 30, 2022? Use a pivot table to deter amount in the blue cell only. Bonus (2 marko mount in the blue cell only. Bonus (2 marks) this amount and enter the TRANSACTION ANALYSIS COMPLETED BY ACCOUNTANT (a) Accounts Impacted Type of Account Debit/ Credit Amount Total Revenue Balance Cash Asset Increase Debit 80,000 ( b ) Common Shares Common Shares Increase Credit 80,00 Total Cast Balance Utilities Expense Expense Increase Debit 4,000 Cash Asset Decrease Credit (4,000) Service Revenue Revenue Increase Credit 100,000 CLICK ON PIVOT TABLE BELOW TO ANALYZE 10 Cash Asset Increase Debit 100,000 Inventory Asset Increase Debit 8,000 PivotTable2 12 Cash Decrease Credit (8,000) Wages Expense Expense Increase Debit 6,000 Wages Payable iability Increase Credit 6,000 15 Accounts Receivable Asset Increase Debit 21,000 Service Revenue Revenue Increase Credit 21,000 17 Wages Payable Liability Decrease Debit (6,000) 18 Cash Asset Decrease Credit (6.000) 19 >A Cover Sheet Formula Sheet Question 1 Journal Entries Question 1 Bonus. Question 2 Income Statement Question 3 Closing Entries Question 4 M + Calculation Mode: Automatic Workbook Statistics DELL