Question

27. Which of the following chart types can be created as a PivotChart? Select all the options that apply. a. Column b. Scatter c. Line d. Area

28. You should not move a PivotChart because it must be on the same worksheet as its PivotTable. a. True b. False

29. Which of the following formatting options can you apply to PivotCharts and other Excel charts? Select all the options that apply. a. Quick Layout b. chart style c. show/hide field buttons d. value number format

Answer 1

Which of the following chart types can be created as a PivotChart? Select all the options that apply

Ans. You can use these chart from the PivotTable tools options.

a)Column

b)Line,

c)Scatter,

d)Area

All these charts can be created as Pivot Chart.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Yes it is true, we can move a PivotChart on the another worksheet.

The following are the ways or steps:-

1)Go to the PivotTable.

2) Then click on the PivotTable tools.

3)Then go on the Analyze tab, here the option of move PivotTable comes.

4) Now, you can choose the available options, where you want to move it like another worksheet or somewhere.

Which of the following formatting options can you apply to PivotCharts and other Excel charts.

Ans. Yes, we can apply all these formatting on pivot chart.

1) Quick layout:-First select the PivotTable and then this option is available in the design tab of PivotTable tools.

2)Chart type:- First select the Chart, and then you can select the Chart type from the design tab.

3) Show/hide field option:- First select the cell then go to the PivotTable and select display options. Here you can choose or hide the fields.

4) Value number format:- First click on the Format cell and then select the Number Format. Here you can select.

Please upvote it?