DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cells
|
|
|
Rows
|
|
|
Categories
|
|
|
Fields
|
Detailed explanation-1: -At the bottom of the PivotTable Field List pane are the four areas of the pivot table: Report Filter, Column Labels, Row Labels, and Values. If you used a Recommended PivotTable layout, you will see the fields from that layout in those areas.
Detailed explanation-2: -The Field List has a field section in which you pick the fields you want to show in your PivotTable, and the Areas section (at the bottom) in which you can arrange those fields the way you want. and then pick the layout you want.
Detailed explanation-3: -In the PivotTable, right-click the row or column label or the item in a label, point to Move, and then use one of the commands on the Move menu to move the item to another location.
Detailed explanation-4: -Under PivotTable Tools, on the Analyze tab, click Move PivotTable.