USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Columns
|
|
|
Filters
|
|
|
Rows
|
|
|
Values
|
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: -Click and hold a field name in the field section, and then drag the field to the Values area in the layout section.
Detailed explanation-3: -Click anywhere in the table. Go to the Table tab on the Ribbon. In the Table Style Options group, select the Header Row check box to hide or display the table headers. If you rename the header rows and then turn off the header row, the original values you input will be retained if you turn the header row back on.