Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Qualitative Analysis Regarding Bangladesh Loan Market.

Answered: 1 week ago