Chart of Accounts - Basic Completing this activity will help you learn to: - Classify business accounts. - Extract information from a data set using Excel pivot tables. Scenario: Company A sells admission to its entertainment facility and sells products in its gift shop. The company has a chart of accounts relevant to its operations. The company bilis its customers for services performed. Each customer has its own account. The Data worksheet contains a list of account names and respective account types. Company A's chart of accounts appears in random order. Each row provides information about one account, including its account type. Accounts receivable accounts are further defined by customer name in column D. Open spreadsheet Steps to create a pivot table: \$1. Select a cell in the data on the Data worksheet. 52. Select Insert / PivotTable. The data range will automatically be inserted. A "Create Pivottable" window should appear: 53. In the window, under "Choose where you want the Pivotrable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTabie. 54. A PivotTable Field List should pop up. Drag fields into rows, columns, fiters, and values areas as needed. (Ir this oray work box does not appear, right click in the pivot table and select "Show Field List,") Questions: S1. Select a cell in the data on the Data worksheet. 52. Select Insert/ PivotTabie. The data range will automatically be inserted, A "Create PivotTable" window should appear 53. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, fiters, and volues areas as needed, (If this gray work box does not appear, right click in the pivot table and select "Show Field List.") Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. How many accounts does the company have, assuming all Accounts Receivable accounts are considered separately? Q2. How many revenue and expense accounts does the company have? Q3. What is the name of the 22 nd customer if customer names are listed alphabetically? Raf Company Ahmed Company Susman Company Onyx Company Q4. How many asset accounts does the company have, assuming all customer accounts are combined into one Accounts Receivable controlling account? Q5. Based on the chart of accounts information given, which of the following is true? The Account Rewivelif account keeps track of amounts owed by custoesen. Renines Earminger and Fect Earned are revenoe accounts. The Commun Slock account invohes sales of semices to customers