Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: Take the journal entries and create a trial balance. Ask the Question: Can PivotTables be used to post journal entries and create a trial balance? Master the Data: AttackID is formed to sell privacy and cybersecurity. AttackID begins business January 1, 2022, and has 52 journal entries in the first month, which we have now input into an Excel spreadsheet. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 1-1 Data.xlsx. Perform the Analysis: Refer to Lab 1-1 in the text for instructions and steps for each the of lab parts. Share the Story: Once we have completed the trial balance and it, in fact, balances, we are ready to publish the balance sheet and the income statement for all interested stakeholders. Date JE# 1/3/22 1/3/22 1/3/22 1/3/22 1/3/22 1/3/22 1/5/22 1/5/22 1/6/22 1/6/22 1/7/22 1/7/22 1/7/22 1/7/22 1/8/22 1/8/22 1/8/22 1/8/22 1/9/22 1/9/22 1/9/22 1/9/22 1/9/22 1/9/22 1/10/22 1/10/22 1/10/22 Account Name 1 Cash 1 Common Stock 2 Travel Expense 2 Cash 3 Building 3 Cash 4 Utilities Expense 4 Cash 5 Equipment 5 Notes Payable 6 Salaries Expense 6 Cash 7 Payroll Tax Expense 7 Cash 8 Accounts Receivable 8 Service Revenue 9 Cash 9 Notes Payable 10 Repairs Expense 10 Cash 11 Accounts Receivable 11 Service Revenue 12 Cash 12 Accounts Receivable 13 Utilities Expense 13 Cash 14 Rent Expense Debit Credit Entered 50,000 VR 50,000 VR 250 VR 250 VR 32,000 VR 32,000 VR 1,600 VR 1,600 VR 19,300 VR 19,300 VR 5,200 VR 5,200 VR 1,100 VR 1,100 VR 10,000 VR 10,000 VR 12,000 VR 12,000 VR 7,000 VR 7,000 VR 20,000 VR 20,000 VR 10,000 VR 10,000 VR 1,300 MW 1,300 MW 7,000 MW Approved AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC DH DH DH DH DH DH DH 1,000 DH DH DH DH 15,000 3,000 DH DH 400 600 5,200 1/11/22 1/11/22 1/11/22 1/11/22 1/12/22 1/12/22 1/13/22 1/13/22 1/13/22 1/14/22 1/14/22 1/14/22 1/14/22 1/15/22 1/15/22 1/15/22 1/15/22 1/16/22 1/16/22 1/16/22 1/16/22 1/16/22 1/16/22 1/16/22 1/16/22 1/17/22 1/17/22 1,100 15 Notes Payable 15 Cash 16 Accounts Receivable 16 Service Revenue 17 Notes Payable 17 Cash 18 Supplies 18 Computer Supplies 18 Cash 19 Salaries Expense 19 Cash 20 Payroll Tax Expense 20 Cash 21 Travel Expense 21 Cash 22 Insurance Expense 22 Cash 23 Cash 23 Service Revenue 24 Training Expense 24 Cash 25 Misc. Expense 25 Cash 26 Travel Expense 26 Cash 27 Travel Expense 27 Cash DH DH DH DH DH DH DH DH MW 1,000 MW MW 15,000 MW MW 3,000 MW MW MW 1,000 MW MW 5,200 MW MW 1,100 MW VR 2,025 VR VR 1,200 VR VR 23,000 VR VR 500 VR VR 50 VR VR 200 VR MW 2,025 MW 2,025 DH DH 1,200 23,000 500 DH DH DH DH DH DH DH DH 50 200 DH DH 2,025 DH 250 2,000 AC AC AC AC AC 5,200 AC 1,100 1,200 2,400 272 1/17/22 1/17/22 1/19/22 1/19/22 1/21/22 1/21/22 1/21/22 1/21/22 1/22/22 1/22/22 1/22/22 1/22/22 1/22/22 1/22/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/23/22 1/24/22 1/24/22 1/24/22 28 Travel Expense 28 Cash 29 Cash 29 Accounts Receivable 30 Salaries Expense 30 Cash 31 Payroll Tax Expense 31 Cash 32 Accounts Receivable 32 Service Revenue 33 Cash 33 Service Revenue 34 Travel Expense 34 Cash 35 Training Expense 35 Cash 36 Misc. Expense 36 Cash 37 Travel Expense 37 Cash 38 Travel Expense 38 Cash 39 Travel Expense 39 Cash 40 Training Expense 40 Cash 41 Cash VR 250 VR VR 2,000 VR MW 5,200 MW MW 1,100 MW MW 1,200 MW MW 2,400 MW MW 272 MW VR 500 VR VR 125 VR VR 350 VR VR 2,025 VR VR 250 VR MW 400 MW MW 500 125 AC AC AC AC AC AC AC VR VR AC AC AC AC AC AC AC AC AC AC AC 350 2,025 250 400 2,200 AC AC AC AC AC AC AC AC AC AC 1/24/22 1/24/22 1/24/22 1/25/22 1/25/22 1/25/22 1/25/22 1/25/22 1/25/22 1/28/22 1/28/22 1/28/22 1/28/22 1/29/22 1/29/22 1/29/22 1/29/22 1/29/22 1/29/22 1/30/22 1/30/22 1/31/22 1/31/22 AC 2,200 MW MW 250 MW MW 12,000 MW MW 200 MW MW 255 MW MW 5,200 MW MW 1,100 MW VR 6,000 VR VR 1,000 VR VR 400 VR VR 200 VR 41 Service Revenue 42 Travel Expense 250 42 Cash 43 Cash 12,000 43 Accounts Receivable 44 Computer Supplies 200 44 Cash 45 Supplies Expense 255 45 Supplies 46 Salaries Expense 5,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 6,000 48 Allowance for Doubtful Accounts 49 Depreciation Expense 1,000 49 Accumulated Depreciation 50 Training Expense 400 50 Cash 51 Insurance Expense 200 51 Prepaid Insurance 52 Cash 21,000 52 Service Revenue AC AC AC AC AC AC AC AC AC VR 21,000 VR