DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Pivot Table Fields
|
|
|
handles
|
|
|
legend keys
|
|
|
Fill
|
Detailed explanation-1: -To see the PivotTable Field List: Click any cell in the pivot table layout. The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected.
Detailed explanation-2: -Click the PivotTable. This displays the PivotTable Tools tab on the ribbon. To switch between showing and hiding field headers, on the Analyze or Options tab, in the Show group, click Field Headers.
Detailed explanation-3: -Method #1: Show the Pivot Table Field List with the Right-click Menu. Probably the fastest way to get it back is to use the right-click menu. Right-click any cell in the pivot table and select Show Field List from the menu.
Detailed explanation-4: -The PivotTable Fields list has two tabs − ACTIVE and ALL that appear below the title and above the fields list. The ALL tab is highlighted. Note that the ALL tab displays all the data tables in the Data Model and ACTIVE tab displays all the data tables that are chosen for the Power PivotTable at hand.