Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Thanks in advance.. please show any formula if possible. EA1-R1 Display the Accounting Equation In this exercise, you will enter the beginning and ending accounting

Thanks in advance.. please show any formula if possible. image text in transcribed
image text in transcribed
image text in transcribed
EA1-R1 Display the Accounting Equation In this exercise, you will enter the beginning and ending accounting equations in beginning assets equal $62,000 and the beginning liabilities equal $19,000 liabilities increased by $13,000 and equity increased by $4,000. 1. Create a Blank Workbook and save the file in your Chapter 01 folder as EA1-R1-AcctEquation-[YourName] You will begin by formatting the cells into which you'll enter the t the range A1:E1, choose Home- Font-Bold, and then click Center 3. Using Tab to navigate and Enter] to complete the fina entry, type the beginning accounting equation into the range A1:E1. 1 Assets -Liabilities + Equity The accounting equation headers appear in row 1 with the bold formatting and center alignment you applied in the previous step. 4. In cell A2, type the beginning asset dollar amount and tap [Tab Hint: Here and throughout, refer to the exercise instructions for the dollar amounts to enter within the accounting equations 5. Type- and tap Tab], type the beginning liability dollar amount and tap [Tab], type + and tap Tab], and then type the beginning equity dollar amount and tap Lab) As this is the beginning accounting equation, the spreadsheet should indicate this fact. To accomplish this, you will now enter a description in cell F2. 6. In cell F2, type Beginning Accounting Equation and tap Ertor 7. Select cell A2, hold Cri, select cells C2 and E2, and release CTr You have highlighted the three dollar amounts in the beginning accounting equation. You weill now apply a number format to these dolar amounts simultaneously 8. Choose Home-Number +Accounting then click Decrease Decimal twice. 9. In cell A3, enter the ending asset dollar amount and tap [Tab 10. Type and tap [Tab], type the ending liability dollar amount and tap [Tab) type + and tap Tab), and then type the ending equity dollar amount and tapTab 11. In cell F3, type Ending Accounting Equation and tap Enter 12. Select cell F3, choose Home->Cells-Format- Column Width, type 30, and click OK 13. Select cell A3, hold Ctrl, select cells C3 and E3, and release [Cri 14. Choose Home->Number-Accounting and then click Decrease Decimal twice. 15. Highlight the range B2:B3, hold Crl), highlight the range D2:D3, release Crl), and choose Home->Alignment->Center 16. Highlight the range A1:F3 and choose File-Print

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

Recommended Textbook for

Commercial Energy Auditing Reference Handbook

Authors: Steve Doty

2nd Edition

1439851972, 978-1439851975

More Books

Students also viewed these Accounting questions