USING MICROSOFT EXCEL
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. Select the row or column label item that you want to move, and then point to the bottom border of the cell.