Question: Please use Microsoft Excel EA1-R1 Display the Accounting Equation In this exercise, you will enter the beginning and ending accounting equations in Excel. The beginning

Please use Microsoft ExcelPlease use Microsoft Excel EA1-R1 Display the Accounting Equation In this exercise,you will enter the beginning and ending accounting equations in Excel. Thebeginning assets equal $62,000 and the beginning liabilities equal $19,000. During the

EA1-R1 Display the Accounting Equation In this exercise, you will enter the beginning and ending accounting equations in Excel. The beginning assets equal $62,000 and the beginning liabilities equal $19,000. During the year, 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 accounting equation. 2. Highlight the range A1:E1, choose HomeFontBold, and then click Center 3. Using [Tab] to navigate and Enter to complete the final 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. 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 4. 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 [Tab 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 Enter 7. Select cell A2, hold Ctril, select cells C2 and E2, and release Ctrl

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!