DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click on the Insert Pivot Table button and select PivotTable Fields List.
|
|
|
Go to the Backstage View and in the Options dialogue box, click on the PivotTable tab. Check the box for PivotTable Fields List.
|
|
|
Click on the Field List button in the Show group, under Options in the PivotTable Tools contextual tab.
|
|
|
All of the options listed above are correct.
|
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: -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.
Detailed explanation-3: -To Unhide tables and fields, return to Power Pivot: Power Pivot > Manage, right-click the item to unhide, and select Unhide from Client Tools. Back in Power View, in your Fields list, you can see the fields that were Unhidden.
Detailed explanation-4: -Right-click any cell in the pivot table and select Show Field List from the menu. This will make the field list visible again and restore it’s normal behavior. The field list will disappear when a cell outside the pivot table is selected, and it will reappear again when a cell inside the pivot table is selected.