Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To complete this exercise, download the starting exercise file named EA1_A2_JournalEntries-eStart that is attached to this assignment. Then follow the EA1-A2 instructions in your Labyrinth
To complete this exercise, download the starting exercise file named EA1_A2_JournalEntries-eStart that is attached to this assignment. Then follow the EA1-A2 instructions in your Labyrinth Learning textbook. In this exercise, you will record four journal entries in Excel. Access the proper file. (Your starting file is intentionally blank.) - Using Project Grader. Download EA1-A2-JournalEntrles-estart. - Not using Project Grader: Open EA1-A2-JournalEntrles. Transactions (all took place in 2026) February 4: Purchased $1,100 of supplies on account February 12 : Received $2,600 of Service Revenue February 17: Paid \$3,100 for Rent Expense February 27: Recorded an adjusting journal entry for Supplies Expense after determining the value of remaining supplies is $350 (the company had no supplies prior to February) Rows 13, first transaction: - Row 1: Enter the first transaction (column A: date with year, column B: debited account, column D: debited amount). (PG-1a) - Row 2: Cell C2 = credited account, cell E2 = credited amount (PG-1b) - Row 3: Cell B3 = explanation for the transaction (PG-1c) Rows 4-6: Enter the second transaction. (PG-2) Rows 7-9: Enter the third transaction. (PG-3) Rows 10-12. Enter the fourth transaction. (PG-4) All Transactions: - All dates: Short Date format (PG-5a) - All amounts: Accounting number format, zero decimals (PG-5b) - Columns A and C-E width: AutoFit simultaneously using one command. (PG-5c) - Column B: Set the width to exactly 5. (PG-5d) - Explanations: Italicize each, using a keyboard shortcut for the first and second and the Ribbon for the third; copy the formatting in cell B9 to cell B12. (PG-5e) - Print area: First two journal entries (including explanations) (PG-5f) Save and close the file. Using Project Grader: Save the file as EA1-A2-JournalEntrles-eSubmission and attach it to the assignment you submit for grading - Not using Project Grader: Submit the file per your instructor's guidelines
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started