Steps to create a pivot table:

S$1.$ Select a cell in the data on the Data worksheet.

S$2.$ Select Insert $/$ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear.

S$3.$ 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 S$4.$ 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 th 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.

Q$1.$ What is the total amount of all assets?

Q$2.$ What is the total amount of all liabilities?

Q$3.$ What is the total amount of stockholders' equity?

Q$4.$ What is the total amount on the right side of the accounting equation?

Q$5.$ What is the accounting equation?

Acsete $=$I iahilitiee $-$ Ctarlhaldere' Fanitu