$100\%$

Create a PivotTable.

Move your cursor to cell A$1.$

Select Insert from the menu and click the PivotTable icon.

Accept the default values for the Table$/$Range and New Worksheet by clicking OK$.$

On the left of your screen, you'll see the area where your PivotTable will be built.

To the right of your screen, you will see all the fields $($columns$)$ listed, along with four areas of the PivotTable.

If you click outside the PivotTable, the fields area will disappear. It will reappear when you click on the table.

Question $5$: What is the last Field in the list of PivotTable Fields?

PivotTable Fields

Choose fields to add to report:

Search.

Ticker

Name

Industry

Year

Total Assets $($M$)$

Total Debt $($M$)$

Net Revenue $($M$)$

COGS $($M$)$

Debt to Asset Ratio

Gross Margin $\%$

Gross Margin $\%$

Build your PivotTable.

Add values and rows to the table.

First, click the Net Revenues field.

You'll see Sum of Net Revenues in the Values area.

Next click on Year, and you may see it appear in the columns and values areas.

Unclick Year and drag Year to the Rows area.

Your Pivot Fields area should look like this:

Question $6$: What number shows for Sum of Net Revenues in $2015?$