Videos
Open P2WORK4 and click the Chart sheet tab. On the screen, a pie chart shows the percentage composition of the total expenses of Sports Connection. Enter the percentages in the spaces provided.
Compare the percentages of Sports Connection with the national statistics provided. Comment on the differences noted. Why might depreciation, utilities, and rent (as a group) be so far off from the national percentages? Any explanation for salaries? Cost of goods sold? When the assignment is complete, close the file without saving it again.
TICKLERS (optional)
Worksheet. You prepared a
Chart. Using the P2WORK4 file, create a column chart showing the dollar total of each of the expenses (except Cost of goods sold) of Sports Connection. Use the Chart Data Table as a basis for preparing the chart. Use appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as P2WORK4. Select the chart and then print it out.
Want to see the full answer?
Check out a sample textbook solution
Chapter 3 Solutions
Excel Applications for Accounting Principles
- What effect does recording depreciation expense have on the accounting equation?A. Increases assets and increases equityB. Decreases assets and decreases equityC. Increases liabilities and decreases equityD. No effect on assets or equity No AIarrow_forwardNo ai 9. In a perpetual inventory system, what happens when goods are sold?A. Only sales revenue is recordedB. Inventory and cost of goods sold are updated immediatelyC. Inventory is updated at the end of the accounting periodD. Only cost of goods sold is recordedAnswer: Barrow_forwardSolve this question with accounting questionarrow_forward
- Hello tutor solve this situation with accounting questionarrow_forwardWhat effect does recording depreciation expense have on the accounting equation?A. Increases assets and increases equityB. Decreases assets and decreases equityC. Increases liabilities and decreases equityD. No effect on assets or equity helparrow_forwardWhat effect does recording depreciation expense have on the accounting equation?A. Increases assets and increases equityB. Decreases assets and decreases equityC. Increases liabilities and decreases equityD. No effect on assets or equityarrow_forward
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning