lab 1-1 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.
Lab 1-2: 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 Alt Data.xlsx.
Perform the Analysis: Refer to Lab 1-2 Alternative in the text for instructions and Lab 1-2 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.
Lab 1-3: 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:
1. Calculate the monthly payment for a 30-year mortgage loan.