Question

e. If you want to analyse the data using a Pivot table, which fields will you
drag into the Row Fields, Column Fields, Page Fields and Data Fields?

Answer 1

Answer:

The Field List should appear when you click anywhere in the PivotTable. If you click inside the PivotTable but don't see the Field List, open it by clicking anywhere in the PivotTable. Then, show the PivotTable Tools on the ribbon and click Analyze> Field List.

Field List option on the ribbon