Required information

Skip to question

[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.

rev: 09_21_2020_QC_CS-228676

Upload the Word or PDF document containing your Lab screenshots using the button below.

Take a screenshot of your final trial balance and label it Lab 1-1 Submission.