Question: EA1-A2 Record Journal Entries PG In this exercise, you will record four journal entries in Excel. Access the proper file. (Your starting file is

EA1-A2 Record Journal Entries PG 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-JournalEntries-eStart Not using Project Grader. Open EA1-A2-JournalEntries. 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 1-3, 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-Journal Entries-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
To complete this exercise and record the journal entries in Excel follow these detailed steps Step 1 Set Up the Spreadsheet 1 Open the Excel starting ... View full answer
Get step-by-step solutions from verified subject matter experts
