FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
After inserting a Pivot Table, the Pivot Table Field List does not automatically appear. How can you activate this area?
A
Click on the Insert Pivot Table button and select PivotTable Fields List.
B
Go to the Backstage View and in the Options dialogue box, click on the PivotTable tab. Check the box for PivotTable Fields List.
C
Click on the Field List button in the Show group, under Options in the PivotTable Tools contextual tab.
D
All of the options listed above are correct.
Explanation: 

Detailed explanation-1: -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.

Detailed explanation-2: -Right click at any cell of the pivot table, and select Hide Field List option from the context menu. If you want to show the Field List again, right click at the pivot table, and select Show Field List.

Detailed explanation-3: -If the PivotTable Field List task pane does not appear automatically, follow these steps to enable it: Click any cell in the pivot table layout. On the Excel Ribbon, click the PivotTable Analyze tab. Then in the Show group (at the far right), click the Field List command.

There is 1 question to complete.
Previous
Next