USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
design
|
|
|
layout
|
|
|
format
|
|
|
analyze
|
Detailed explanation-1: -On the Ribbon, under the PivotTable Tools tab, click the Design tab. In the PivotTable Style options gallery, right-click on the style that you want to set as the default.
Detailed explanation-2: -Change PivotChart Type Click the Design tab on the ribbon. Click the Change Chart Type button. Select a new chart type and click OK.
Detailed explanation-3: -Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Design, and then click the More button in the PivotTable Styles gallery to see all available styles. Pick the style you want to use. If you don’t see a style you like, you can create your own.
Detailed explanation-4: -An Excel pivot chart layout is tied to the layout of the pivot table it’s connected to. If you change the pivot chart layout, the pivot table will also change, and vice versa.