Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Subtotal Function

    Uploaded by

    Nyasha Makore
    The document provides sample exercises for using the Subtotal function in Excel. The exercises include creating subtotals and totals for a balance sheet, department report, and SG&A expenses sheet.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Subtotal Function

    Uploaded by

    Nyasha Makore
    13 views4 pages
    The document provides sample exercises for using the Subtotal function in Excel. The exercises include creating subtotals and totals for a balance sheet, department report, and SG&A expenses sheet.

    Original Description:

    2

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides sample exercises for using the Subtotal function in Excel. The exercises include creating subtotals and totals for a balance sheet, department report, and SG&A expenses sheet.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views4 pages

    Subtotal Function

    Uploaded by

    Nyasha Makore
    The document provides sample exercises for using the Subtotal function in Excel. The exercises include creating subtotals and totals for a balance sheet, department report, and SG&A expenses sheet.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Start Here

    Click Consulting
    Purpose To provide sample exercises for using the Subtotal function.

    Topics
    The topics covered are:

    Sheet Topic
    Exercise 1 Balance Sheet
    Exercise 2 Department Report
    Exercise 3 SG&A
    Exercise 1
    Click Consulting
    Exercise Using the techniques presented in the book, please perform the following:
    Create a Fixed Assets subtotal (should total $670,868)
    Create a Total Assets total (should total $2,049,048)

    Partial Balance Sheet - Assets

    Cash 124,864
    Accounts Receivable 752,441

    Furniture and Fixtures 185,112


    Computer Equipment 225,986
    Machinery 160,205
    Automobiles 99,565
    Fixed Assets

    Goodwill 500,875

    Total Assets
    Exercise 2
    Click Consulting
    Exercise Using the techniques presented in the book, please perform the following:
    Insert functions to compute the Group subtotals
    Insert functions to propertly compute the Company Total

    Department Report

    DeptID Department Q1 Q2 Q3 Q4
    100 Corporate $149,617 $255,652 $219,500 $349,062
    101 Accounting $359,334 $194,638 $456,301 $205,269
    102 HR $491,038 $468,210 $367,590 $169,858
    Group Subtotal

    200 Operations $239,752 $392,538 $283,061 $336,198


    202 Research $101,058 $399,246 $367,008 $188,655
    206 Manufacturing $357,508 $192,768 $106,349 $237,665
    Group Subtotal

    301 Sales $298,198 $471,041 $167,329 $137,880


    305 Marketing $397,510 $256,609 $356,504 $499,822
    Group Subtotal

    400 Logistics $457,376 $320,175 $289,996 $163,913


    410 IT $276,611 $105,785 $365,720 $483,014
    420 Warehouse $398,523 $291,788 $266,605 $167,764
    Group Subtotal

    Company Total
    Exercise 3
    Click Consulting
    Exercise Using the techniques presented in the book, please perform the following:
    Insert functions to compute all subtotal lines
    Insert a function to compute the total line

    SG&A

    AcctNum Account Amount


    5020 Wages $56,825
    5021 Salary $29,259
    5022 Overhead $49,038
    Labor Subtotal

    5040 Marketing $70,278


    5041 Trade shows $97,742
    Marketing Subtotal

    5050 Computer software $66,347


    Software Subtotal

    5053 Telephone $76,855


    5054 Internet $20,850
    Communications Subtotal

    5055 Travel $61,220


    5056 Meals and Entertainment $70,230
    Travel M&E Subtotal

    5030 Office supplies $28,738


    5051 Small office equipment $31,639
    5052 Postage $43,116
    Other Supplies Subtotal

    Total SG&A

    You might also like