Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

work must be on microsoft excel Instructions for Excel 2016: To open Microsoft Excel 2016, click on the Start menu, click All Programs, click Microsoft

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
work must be on microsoft excel
Instructions for Excel 2016: To open Microsoft Excel 2016, click on the Start menu, click All Programs, click Microsoft Office and then click Excel 2016. Excel opens with a blank workbook. When you open a new workbook, It contains one worksheet. The sheet tab is located just above the status bar (bottom of the screen) and identified as Sheet1 Until you are well acquainted with the Ribbons tabs and the Command groups within each tab, you may want to use Excel's Help to find the location of a particular command. To open Help, click the question mark on the top right side of the screen next to the maximize and minimize buttons. Here are step-by-step Instructions to complete your project. As new concepts are introduced, the instructions will be very explicit. If, in later steps, you don't remember how to do something, simply refer back to where a particular concept was first introduced. Springer's Cleaners is owned and operated by George Springer. Until Mr. Springer is ready to build, he is currently renting the building and equipment. The current balance sheet of the business is as follows: Springer's Cleaners Balance Sheet October 31, 2019 Assets Cash Accounts Receivable Supplies Land Total Assets $ 39,000 80,000 11,000 50,000 $180.000 Liabilities & Stockholders' Equity Accounts Payable $ 31,500 Common Stock 50,000 Retained Earnings 98.500 Total Liabilities & Stockholders' Equity $180.000 Required: 1. Create T-accounts. Place the beginning balances in each account. 2. Record the necessary Journal entries for November, 3. Post these entries to the appropriate T-account. 4. Prepare a Trial Balance. Accounting 201 Working Papers - SPRING 2020 72.000. (This is Service Revenue). November Transactions: 1. Pald rent for month $4000. 2. Charged customers for cleaning on accounts 3. Purchased supplies on account. $12,000. 4. Pald wage expense, $40,000 5. Pald dividends. $6,000 6 Collected $50,000 from customers on account. ghlighted. Click "format 1. Open an Excel workbook. Right click on "Sheet1" tab. Click on "Rename. Rename the tab "Journal Entries 3. Click Cell A2. Enter "Rent Expense" 4. Click Cell C2. Enter "4000" e Right click the column header "C. Make sure entire column is highlighted Cells". Make sure that the pop-up box is on the first tab - "Number". Select the category, "Number". Set decimal places to "O and check the box that says "Use 10 Separator". Click "OK" 6. Click Cell B3. Enter "Cash" 7. Click Cell D3. Enter "4000" & Right click the column header "D". Make sure entire column is highlighted. Click Form Cells". Make sure that the pop-up box is on the first tab - "Number". Select the second category, "Number". Set decimal places to "O and check the box that says "Use 1000 Separator'. Click "OK" 9. Click AS. Enter "Accounts Receivable". Move your cursor to the right side of Column AG the "line" between A and B and your cursor should change from an arrow to a cross- Double click the line (while the cursor is a cross) and Column A should expand to fit the text entered. 10. Click CS. Enter 72000. 11. Click B6. Enter Service Revenue". Move your cursor to the right side of Column B. Click the "line" between B and C and your cursor should change from an arrow to a cross T. Double click the line (while the cursor is a cross) and Column B should expand to fit the te entered. 12. Click D6. Enter "72000" 13. Click A8. Enter "Supplies" 14. Click C8. Enter "12000 15. Click B9. Enter "Accounts Payable" 16. Click D9. Enter "12000" 17. Click A11. Enter "Wage Expense" 18. Click C11. Enter 40000" 19. Click B12. Enter "Cash" 20. Click D12. Enter 40000 21. Click A14. Enter "Dividends 22. Click C14. Enter "6000" 23. Click B15. Enter "Cash" 24. Click D15. Enter "6000" 25. Click A17. Enter "Cash" Accounting 201 Working Papers - SPRING 2020 26. Click C17. Enter "50000 27. Click B18. Enter "Accounts Receivable. You may need to resize the column width. See 119. 28. Click D18. Enter "50000" A.EE ODEBERGER 29. Click on add sheet icon (see above) 30. Change name of Sheet2 to "T-Accounts". Refer back to N2, if needed JB Copy file Home Insert Page Layout Formulas Data Review View Developer for * Cut Arial .14 BAA == > PWrap Tot Paste Format Painter BTU. S.A. Merge & Center Clipboard Font Alignment 31. Click B2. On the ribbon at the top, click the Insert tab. In the illustrations box, click arrow below "Shapes". Choose first image on left under Lines. Your cursor will change to a crosshair. Draw line across the bottom of B2 & C2. Drawing Tools will be open. Click "Format". In the Shape Styles, choose the first line on the left. That will turn your line to black. 32. Repeat the process, only this time draw a vertical line between B & C (from row 3 to row 10). 33. While holding the Control key, click on each line. (Both should be highlighted). Choose Format under Drawing Tools, again. This time choose the arrow under "Group". (This is in the Arrange group on the right side of the ribbon.) Click "Group". This will allow both lines to move Accounting 201 Working Papers - SPRING 2020 and select "Copy. Now 16. 129. E29 and H29. You should have two B2 it is the 3 02. Click group). This center the text over each. See #34. Now you have a T-Account. Highlight the group. Right click and select move to your right and copy the image 11 times, follows: a) Click E3. Right click and hit "Paste. b) Repeat in H3, K3, B16, E16, H16, K16, B29, E29 and 17 T-Accounts with four on each row and one row with three T-Account won the Home tab. Click B2. EnterCash. Highlight B2 34. Make sure that you are back on the Home tab. Click B2. Ento on "Merge & Center found in the Alignment group on the ribbon. (it is the will move the text to the center of the two cells. 25. Name each of the T-Accounts as follows. Then Merge & Center the texto a) E2 - Accounts Receivable b) H2-Supplies c) K2-Land d) 815 - Accounts Payable e) E15 - Common Stock f) H15 - Retained Earnings B) K15 - Dividends h) B28 - Service Revenue i) E28 - Rent Expense D) H28 - Wage Expense 36. Enter the beginning balances in the T-accounts. a) Click B3. Enter "39000" b) Click E3. Enter "80000" c) Click H3. Enter "11000" d) Click K3. Enter "50000" e) Click C16. Enter "31500" f) Click F16. Enter "50000" g) Click 116. Enter "98500" 37. Post Journal Entry #1 a) Click E29. Click "-". Then click on the Journal Entries tab. Click C2. Enter. This should post the $4,000 of rent expense to the left (debit) side of Rent Expense. b) Click C3. Click -". Click on the Journal Entries tab. Click D4, Enter. This should post the payment of $4,000 to the right (credit) side of Cash. 38. Post Journal Entry #2 a) Click E4. Click "=". Click on the Journal Entries tab. Click C5. Enter. Remember, this should post the $72,000 to the left (debit) side of Accounts Receivable. b) Click C29. Click "-". Then click the Journal Entries tab. Click D6. Enter. Remember, this should post the $72,000 to the right (credit) side of Service Revenue. 39. Post Journal Entry #3. a) Click H4. Click "-". Click on the Journal Entries tab. Click C8. Enter. b) Click C17. Click "-". Click on the Journal Entries tab. Click D9. Enter. 40. Post Journal Entry #4. a) Click H29. Click ".". Click on the Journal Entries tab. Click C11. Enter b) Click CA. Click "-". Click on the Journal Entries tab. Click D12. Enter. 41. Post Journal Entry #5. Accounting 201 Working Papers - SPRING 2020 a) Click 16. Click . Click on the Journal Entries tab. Click C14. Enter. b) Click CS. Click "-. Click on the Journal Entries tab. Click D15. Enter. 42. Post Journal Entry 6. c) Click B4. Click "". Click on the journal Entries tab. Click C17. Enter. d) Click F3. Click . Click on the Journal Entries tab. Click D18. Enter. 43. Sum the "T Accounts a) Click B10. Type=B3-84-C3-C4-CS". Enter b) Click E10. Type-E3 E4-F3". Enter c) Click H10. Type -H3 H4". Enter d) Click K10. Type -*3. Enter e) Click C23. Type-C16+C17". Enter 1) Click F23. Type -F16". Enter B) Click 123. Type-116". Enter h) Click 23. Type =K16". Enter 1) Click C36. Type "-C29'. Enter D) Click E36. Type -E29". Enter k) Click H36. Type -H29". Enter 44. Add another worksheet. See 129. 45. Change name of Sheet 3 to "Trial Balance 46. Click A1. Type "Springer's Cleaners". Highlight A1:01. Click Merge & Center (See 834). This will move the text in the center of the 3 columns 47. Click A2. Type "Trial Balance". Highlight A2:02. Click Merge & Center (See #34). This will move the text in the center of the 3 columns 48. Click A3. Type "November 30, 2019'. Enter. Right click the cell. Choose Format Cells. Make sure that you are on the Number tab. Highlight Date. Scroll down until you see an example of the date written as you typed it. Select that option and click OK. (This should change the content of the cell to match what you have typed). Highlight A3.C3. Click Merge & Center (See #34). This will move the text in the center of the 3 columns 49. Click S. Type "Debit". Center the text using the Center alignment button below. Home Insert Page Layout Formidas Data Review View Developer X Cut Arial -14 AA== - Wrap Test Paste BIU. B. A 13 Format Painter Merge Center Clipboard Alignment 50. Click C. Type "Credit". Center as you did in #49. 51. Click AB, Type "Cash". Move to B8. Types". Click on the T-Accounts tab and click on B10. Enter. This should place the ending balance in the Cash account (39000) in the Trial Balance on the left or debit side. Make sure that you are on B8, right click and choose Format Cells. You should still be on the Number tab. Choose Currency. Make sure that you are showing in the Decimal places drop down. Click OK. This will add a $ to the current cell. 52. Click A9. Type "Accounts Receivable". Move to B9. Types". Click on the T-Accounts tab and click on E10. Enter. This will place 102000 in cell B9 in the Trial Balance. Do not change the cell format to currency. There should only be $ in the first and last numbers in a column. Accounting 201 Working Papers - SPRING 2020 Fax Da Copy . Type . Click on the T-Accounts tab and he Number tab. Choose Currency. Make 53. Click A10. Type Supplies". Move to B10. Type ". Click on the T-Accounts tab and click H10. Enter. This will place 23000 in cell B10 in the Trial Balance. 54. Click A11. Type "land". Move to B11. Type "=. Click on the T-Accounts tab and click on to Enter. This will place 50000 in cell B11 in the Trial Balance. Format cell to include com needed. 55. Click A12. Type "Accounts Payable". Move to C12. Type ".". Click on the T-Acco click on C23. Enter. This should place the ending balance of 43500 in the Accounts ccounts Payable account in the Trial Balance on the right or credit side. Make sure that you are on C12 rata click and choose Format Cells. You should still be on the Number tab. Choose Currene sure that you are showing in the Decimal places drop down. Click OK. This will add a current cell. 56. Click A13. Type "Common Stock". Move to C13. Type "-". Click on the T-Accounts tab and click on 23. Enter. This will place 50000 in cell C13 in the Trial Balance. Format cell to ir comma if needed. 57. Click A14. Type "Retained Earnings". Move to C14. Type "-". Click on the T-accounts tahan click on 123. Enter. This will place 98500 in C14. Make sure cell is formatted correctly. 58. Click A15. Type "Dividends". Move to B15. Type "". Click on the T-Accounts tab and click on K23. Enter. This will place 6000 in cell B15 in the Trial Balance. Make sure cell is formatted correctly. 59. Click A16. Type "Service Revenue". Move to C16. Type":". Click on the T-Accounts tab and click on C36. Enter. This will place 72000 in cell C16 in the Trial Balance. Make sure cell is formatted correctly. 60. Click A17. Type "Rent Expense". Move to B17. Type "=". Click on the T-Accounts tab and click on C36. Enter. This will place 72000 in cell B17 in the Trial Balance. Make sure cell is formatted correctly. 61. Click A18. Type "Wage Expense". Move to B18. Types". Click on the T-Accounts tab and click on H36. Enter. This will place 40,000 in cell B18 in the Trial Balance. Make sure cell is formatted correctly. File Insert Page Layout Formulas Data Review View Developer Home Cut Copy Arial A A -14 A met Painter B == 1=93 Paste - Wrap Tot Merge &. ce Clipboard Alignment 62. Use the Border button to place a bottom border in cells B18 & C18. Highlight cells B18 &018. Click the drop down arrow in borders. Select "Bottom Border. This will place a line at the bottom of each cell. Accounting 201 Working Papers - SPRING 2020 FILE HOME INSERT PAGE LAYOUT DATA * Cut - 11-AA Paste Format Painter BIU. . . AA Clipboard Font Be Copy AutoSum- Fill- Clear 63. Click B19. Use AutoSum to add together cells B8:818. If AutoSum does not highlight all of these cells, you can either type the cells in, or use your cursor to move the highlight box to include these cells. 64. Click C19. Use AutoSum to add together cells C12:C18. B19 will equal C19. Calibri BIU V B 11 A A . A. Underline Double Underline 65. Highlight B19 & C19. Double underline these cells by using the dropdown arrow to select double underline. Your completed project should look like this: Springer Cleaners Trial Balance November 30, 2019 Debit Credit Cash Accounts Receivable Supplies Land Accounts Payable Common Stock Retained Earnings Dividends Service Revenue Rent Expense Wage Expense $39,000 102,000 23,000 50,000 $43,500 50,000 98,500 6,000 72,000 4,000 40,000 $264,000 $264.000 Accounting 201 Working Papers - SPRING 2020

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_2

Step: 3

blur-text-image_3

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

Financial And Accounting Principles In Islamic Finance

Authors: Samir Alamad

1st Edition

3030162982, 9783030162986

More Books

Students also viewed these Accounting questions

Question

What did Jung mean by the term archetype? Provide examples.

Answered: 1 week ago

Question

LO3 Describe the purpose of equity legislation.

Answered: 1 week ago

Question

LO4 Describe the purpose of privacy legislation.

Answered: 1 week ago