51. Select a cell in the data on the Data worksheet. 52. Select Insert / PivotTabie. The data range will automatically be inserted. A "Create Pivoctable" 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. 54. A Pivot Table Field List should pop up. Drag fields into rows, columns, filters, and values 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. What is the total amount of all assets? Q2. What is the total amount of all liabilities? Q3. What is the total amount of stocholders' equity? Q4, What is the total amount on the right side of the accounting equation? Q5. What is the occounting equation? S1. 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, S3. In the window, under "Choose where you want the Pivot Table 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, filters, and values 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. What is the total amount of all assets? Q2. What is the total amount of all liabilities? Q3. What is the total amount of stockholders' equity? Q4. What is the total amount on the right side of the accounting equation? 1 Q5. What is the accounting equation? 51. Select a cell in the data on the Data worksheet. 52. Select Insert / PivotTabie. The data range will automatically be inserted. A "Create Pivoctable" 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. 54. A Pivot Table Field List should pop up. Drag fields into rows, columns, filters, and values 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. What is the total amount of all assets? Q2. What is the total amount of all liabilities? Q3. What is the total amount of stocholders' equity? Q4, What is the total amount on the right side of the accounting equation? Q5. What is the occounting equation? S1. 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, S3. In the window, under "Choose where you want the Pivot Table 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, filters, and values 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. What is the total amount of all assets? Q2. What is the total amount of all liabilities? Q3. What is the total amount of stockholders' equity? Q4. What is the total amount on the right side of the accounting equation? 1 Q5. What is the accounting equation
