USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
any active cell with showing data
|
|
|
any cell outside of the table
|
|
|
any empty cell
|
|
|
the fx icon
|
Detailed explanation-1: -Follow the steps below to show/hide Pivot Table Field List using the ribbon menu: STEP 1: Click on any cell in the Pivot Table. STEP 2: Go to PivotTable Analyze > Field List. STEP 3: The field list will appear next to the Pivot Table!
Detailed explanation-2: -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.
Detailed explanation-3: -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-4: -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-5: -PivotTable Fields task pane only shows up when you have selected any cell in the pivot table. If you click any cell outside of the pivot table, the fields menu would disappear.