Question: Pleasue use Excel if you can EA 1 - A 2 RECORD JOURNAL ENTRIES PG In this exercise, you will record four journal entries in

Pleasue use Excel if you can
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-A2JournalEntries.
\table[[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 valueof 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).(PG1a)
Row 2: Cell C2= credited account, cell E2= credited amount (PG-1b)
Row 3: Cell B3= explanation for the transaction (PG-1c)
9:38
5Gy
76
Rows 1-3, first transaction:
Row 1: Enter the first transaction (column A: date with year, column B: debited account, column D: debited amount).(PG1a)
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. (PG4)
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. (PG5c)
Column B: Set the width to exactly 5.(PG5d)
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
Pleasue use Excel if you can EA 1 - A 2 RECORD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!