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 sande 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 Alt Data.xlsx Perform the Analysis: Refer to Lab 1-1 Alternative in the text for instructions and Lab 1-1 steps for each of the 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, Part 1: Upload Your Files Part 2: Assessment AutoSave Lab 1-1 Art Data (1) - Excel File Home Insert Page Layout Formulas Data Review View Developer Help X X cut Paste Format Painter IG Calibri -11-AA Wrap Text BIU-- O - A E Mergea Center Clipboard Font Alignment B1 X f JEN H 1 B D E G 1 Date JE# Account Name Debit Credit Entered Approved 2 1/2/2022 1 Cash 50,000 VR AC 3 1/2/2022 1 Common Stock 50,000 VR AC 4 1/2/2022 2 Travel Expense 150 VR AC 5 1/2/2022 2 Cash 150 VR AC 6 1/2/2022 3 Building 30,000 VR AC 7 1/2/2022 3 Cash 30,000 VR AC 8 1/4/2022 4 Utilities Expense 1,500 MW 9 1/4/2022 4 Cash 1,500 MW AC 10 1/5/2022 5 Equipment 17,200 VR AC 11 1/5/2022 5 Notes Payable 17,200 VR AC 12 1/6/2018 6 Salaries Expense 1,300 VR AC 13 1/6/2018 6 Cash 1,300 VR AC 14 1/5/2022 7 Payroll Tax Expense 1,000 VR AC 15 1/5/2022 7 Cash 1.000 VR AC 16 1/6/2022 8 Accounts Receivabl 10,000 VR AC 17 1/6/2022 8 Sales Revenue 10,000 VR AC 18 1/6/2022 9 Cash 11,000 VR AC 19 1/6/2022 9 Notes Payable 1 11.000 VR AC 20 1/7/2022 10 Repairs Expense 7,000 VR AC 21 1/7/2022 10 Cash 7,000 VR AC 22 1/7/2022 11 Accounts Receivabl 20.000 VR DH 23 1/7/2022 11 Sales Revenue 20,000 VR DH 24 1/10/2022 12 Cash 10,000 VR DH 25 1/10/2022 12 Accounts Receivable 10,000 VR DH 26 1/10/2022 13 Repairs Expense 1.300 MW DH 27 1/10/2022 13 Cash 1,300 MW DH 28 1/10/2022 14 Rent Expense 7,000 MW DH 29 1/10/2022 14 Cash 7,000 MW DH Sheet Type here to search o Calibri 11 - A A X Cut Ub Copy Paste Format Painter Clipboard Wrap Text Merge & Center BIU - OA Font Alignment B1 f JE# B D G H 1 1,000 15,000 DH DH DH DH DH DH DH DH 2,000 500 500 DH 5,200 A 30 1/10/2022 31 1/10/2022 32 1/10/2022 33 1/10/2022 34 1/10/2022 35 1/10/2022 36 1/11/2022 37 1/11/2022 38 1/11/2022 39 1/12/2022 40 1/12/2022 41 1/12/2022 42 1/12/2022 43 1/13/2022 44 1/13/2022 45 1/13/2022 46 1/13/2022 47 1/14/2022 48 1/14/2022 49 1/14/2022 50 1/14/2022 51 1/14/2022 52 1/14/2022 53 1/14/2022 54 1/14/2022 55 1/15/2022 56 1/15/2022 57 1/15/2022 58 1/15/2022 1,000 E F VR 1,000 VR VR 15,000 VR MW 2,000 MW MW MW 1,000 MW MW 5,200 MW MW 1,000 MW VR 2,025 VR VR 1,200 VR VR 23,000 VR VR 500 VR 15 Prepaid Insurance 15 Cash 16 Accounts Receivabl 16 Sales 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 Sales Revenue 24 Training Expense 24 Cash 25 Travel Expense 25 Cash 26 Misc. Expense 26 Cash 27 Travel Expense 27 Cash 28 Postage Expense 28 Cash 2,025 1,200 23,000 DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH AC AC 500 50 VR 200 2,025 SO VR VR 200 VR DH 2,025 DH VR 250 VR 250 Sheet1 Type here to search Format Painter EL Merge Center Clipboard Font Alignment B1 X fi JE# E F H D 2,000 G AC AC 5,200 AC AC AC 1,100 AC 1,200 2,400 272 500 A 59 1/17/2022 60 1/17/2022 61 1/19/2022 62 1/19/2022 63 1/19/2022 64 1/19/2022 65 1/20/2022 66 1/20/2022 67 1/20/2022 68 1/20/2022 69 1/20/2022 70 1/20/2022 71 1/21/2022 72 1/21/2022 73 1/21/2022 74 1/21/2022 75 1/21/2022 76 1/21/2022 77 1/21/2022 78 1/21/2022 79 1/21/2022 80 1/21/2022 81 1/22/2022 82 1/22/2022 83 1/22/2022 84 1/22/2022 85 1/22/2022 86 1/22/2022 87 1/23/2022 B 29 Cash 29 Accounts Receivable 30 salaries Expense 30 Cash 31 Payroll Tax Expense 31 Cash 32 Accounts Receivabl 32 Sales Revenue 33 Cash 33 Sales 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 41 Sales Revenue 42 Travel Expense 42 Cash 43 Cash Sheet1 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 2,200 MW MW 250 MW VR 125 350 AC AC AC AC VR VR AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC 2,025 250 400 2,200 250 12,000 Type here to search O a Clipboard Font Alignment B1 JER E F H G AC AC AC AC AC AC AC AC AC AC AC AC 78 1/21/2022 79 1/21/2022 80 1/21/2022 81 1/22/2022 82 1/22/2022 83 1/22/2022 84 1/22/2022 85 1/22/2022 86 1/22/2022 87 1/23/2022 88 1/23/2022 89 1/23/2022 90 1/23/2022 91 1/23/2022 92 1/23/2022 93 1/26/2022 94 1/26/2022 95 1/26/2022 96 1/26/2022 97 1/27/2022 98 1/27/2022 99 1/27/2022 100 1/27/2022 101 1/27/2022 102 1/27/2022 103 1/28/2022 104 1/28/2022 105 1/29/2022 106 1/29/2022 B D 38 Cash 39 Travel Expense 250 39 Cash 40 Training Expense 400 40 Cash 41 Cash 2,200 41 Sales 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 4,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 5,000 48 Allowance for Doubtful Accou 49 Depreciation Exper 1.100 49 Accumulated Depreciation SO Training Expense 300 50 Cash 51 Insurance Expense 150 51 Prepaid Insurance 52 Cash 20,000 52 Sales Revenue Sheet1 2,025 VR VR 250 VR MW 400 MW MW 2,200 MW MW 250 MW VR 12,000 VR MW 200 MW MW 255 MW MW 4,200 MW MW 1,100 MW VR 5,000 VR VR 1,100 VR VR 300 VR VR 150 VR MW 20,000 MW AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC Type here to search O a 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 sande 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 Alt Data.xlsx Perform the Analysis: Refer to Lab 1-1 Alternative in the text for instructions and Lab 1-1 steps for each of the 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, Part 1: Upload Your Files Part 2: Assessment AutoSave Lab 1-1 Art Data (1) - Excel File Home Insert Page Layout Formulas Data Review View Developer Help X X cut Paste Format Painter IG Calibri -11-AA Wrap Text BIU-- O - A E Mergea Center Clipboard Font Alignment B1 X f JEN H 1 B D E G 1 Date JE# Account Name Debit Credit Entered Approved 2 1/2/2022 1 Cash 50,000 VR AC 3 1/2/2022 1 Common Stock 50,000 VR AC 4 1/2/2022 2 Travel Expense 150 VR AC 5 1/2/2022 2 Cash 150 VR AC 6 1/2/2022 3 Building 30,000 VR AC 7 1/2/2022 3 Cash 30,000 VR AC 8 1/4/2022 4 Utilities Expense 1,500 MW 9 1/4/2022 4 Cash 1,500 MW AC 10 1/5/2022 5 Equipment 17,200 VR AC 11 1/5/2022 5 Notes Payable 17,200 VR AC 12 1/6/2018 6 Salaries Expense 1,300 VR AC 13 1/6/2018 6 Cash 1,300 VR AC 14 1/5/2022 7 Payroll Tax Expense 1,000 VR AC 15 1/5/2022 7 Cash 1.000 VR AC 16 1/6/2022 8 Accounts Receivabl 10,000 VR AC 17 1/6/2022 8 Sales Revenue 10,000 VR AC 18 1/6/2022 9 Cash 11,000 VR AC 19 1/6/2022 9 Notes Payable 1 11.000 VR AC 20 1/7/2022 10 Repairs Expense 7,000 VR AC 21 1/7/2022 10 Cash 7,000 VR AC 22 1/7/2022 11 Accounts Receivabl 20.000 VR DH 23 1/7/2022 11 Sales Revenue 20,000 VR DH 24 1/10/2022 12 Cash 10,000 VR DH 25 1/10/2022 12 Accounts Receivable 10,000 VR DH 26 1/10/2022 13 Repairs Expense 1.300 MW DH 27 1/10/2022 13 Cash 1,300 MW DH 28 1/10/2022 14 Rent Expense 7,000 MW DH 29 1/10/2022 14 Cash 7,000 MW DH Sheet Type here to search o Calibri 11 - A A X Cut Ub Copy Paste Format Painter Clipboard Wrap Text Merge & Center BIU - OA Font Alignment B1 f JE# B D G H 1 1,000 15,000 DH DH DH DH DH DH DH DH 2,000 500 500 DH 5,200 A 30 1/10/2022 31 1/10/2022 32 1/10/2022 33 1/10/2022 34 1/10/2022 35 1/10/2022 36 1/11/2022 37 1/11/2022 38 1/11/2022 39 1/12/2022 40 1/12/2022 41 1/12/2022 42 1/12/2022 43 1/13/2022 44 1/13/2022 45 1/13/2022 46 1/13/2022 47 1/14/2022 48 1/14/2022 49 1/14/2022 50 1/14/2022 51 1/14/2022 52 1/14/2022 53 1/14/2022 54 1/14/2022 55 1/15/2022 56 1/15/2022 57 1/15/2022 58 1/15/2022 1,000 E F VR 1,000 VR VR 15,000 VR MW 2,000 MW MW MW 1,000 MW MW 5,200 MW MW 1,000 MW VR 2,025 VR VR 1,200 VR VR 23,000 VR VR 500 VR 15 Prepaid Insurance 15 Cash 16 Accounts Receivabl 16 Sales 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 Sales Revenue 24 Training Expense 24 Cash 25 Travel Expense 25 Cash 26 Misc. Expense 26 Cash 27 Travel Expense 27 Cash 28 Postage Expense 28 Cash 2,025 1,200 23,000 DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH AC AC 500 50 VR 200 2,025 SO VR VR 200 VR DH 2,025 DH VR 250 VR 250 Sheet1 Type here to search Format Painter EL Merge Center Clipboard Font Alignment B1 X fi JE# E F H D 2,000 G AC AC 5,200 AC AC AC 1,100 AC 1,200 2,400 272 500 A 59 1/17/2022 60 1/17/2022 61 1/19/2022 62 1/19/2022 63 1/19/2022 64 1/19/2022 65 1/20/2022 66 1/20/2022 67 1/20/2022 68 1/20/2022 69 1/20/2022 70 1/20/2022 71 1/21/2022 72 1/21/2022 73 1/21/2022 74 1/21/2022 75 1/21/2022 76 1/21/2022 77 1/21/2022 78 1/21/2022 79 1/21/2022 80 1/21/2022 81 1/22/2022 82 1/22/2022 83 1/22/2022 84 1/22/2022 85 1/22/2022 86 1/22/2022 87 1/23/2022 B 29 Cash 29 Accounts Receivable 30 salaries Expense 30 Cash 31 Payroll Tax Expense 31 Cash 32 Accounts Receivabl 32 Sales Revenue 33 Cash 33 Sales 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 41 Sales Revenue 42 Travel Expense 42 Cash 43 Cash Sheet1 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 2,200 MW MW 250 MW VR 125 350 AC AC AC AC VR VR AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC 2,025 250 400 2,200 250 12,000 Type here to search O a Clipboard Font Alignment B1 JER E F H G AC AC AC AC AC AC AC AC AC AC AC AC 78 1/21/2022 79 1/21/2022 80 1/21/2022 81 1/22/2022 82 1/22/2022 83 1/22/2022 84 1/22/2022 85 1/22/2022 86 1/22/2022 87 1/23/2022 88 1/23/2022 89 1/23/2022 90 1/23/2022 91 1/23/2022 92 1/23/2022 93 1/26/2022 94 1/26/2022 95 1/26/2022 96 1/26/2022 97 1/27/2022 98 1/27/2022 99 1/27/2022 100 1/27/2022 101 1/27/2022 102 1/27/2022 103 1/28/2022 104 1/28/2022 105 1/29/2022 106 1/29/2022 B D 38 Cash 39 Travel Expense 250 39 Cash 40 Training Expense 400 40 Cash 41 Cash 2,200 41 Sales 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 4,200 46 Cash 47 Payroll Tax Expense 1,100 47 Cash 48 Bad Debt Expense 5,000 48 Allowance for Doubtful Accou 49 Depreciation Exper 1.100 49 Accumulated Depreciation SO Training Expense 300 50 Cash 51 Insurance Expense 150 51 Prepaid Insurance 52 Cash 20,000 52 Sales Revenue Sheet1 2,025 VR VR 250 VR MW 400 MW MW 2,200 MW MW 250 MW VR 12,000 VR MW 200 MW MW 255 MW MW 4,200 MW MW 1,100 MW VR 5,000 VR VR 1,100 VR VR 300 VR VR 150 VR MW 20,000 MW AC AC AC AC AC AC AC AC AC AC AC AC AC AC AC Type here to search O a