DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
John wants to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create?
|
|
design
|
|
|
layout
|
|
|
format
|
|
|
analyze
|
Explanation:
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 the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
There is 1 question to complete.