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

EA1-A2 Record Journal Entries In this exercise, you will record four journal entries in Excel.

Access the proper file. (Your starting file is intentionally blank.)

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 46: Enter the second transaction. (PG-2)

Rows 79: Enter the third transaction. (PG-3)

Rows 1012: 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 CE 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Question ID 18549775 Topic EA1A2 Journal Entries in Excel Required Journal Entries Below are the fou... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!