MASTERING EXCEL PIVOTTABLES - SECTION 05 REVIEW QUIZ

True or False? You can create a pivotchart from either raw data or from a pivottable.

True

False

Correct! You can create a piovtchart from raw data and from a pivottable.

Incorrect, this statement is true. You can create a piovtchart from raw data and from a pivottable.

Can you individually clear filters from a pivotchart?

Yes

It depends

Incorrect. Just like a pivottable, you can individually clear filters from a pivotchart.

Correct! Just like a pivottable, you can individually clear filters from a pivotchart.

No, it doesn't depend on anything. Just like a pivottable, you can individually clear filters from a pivotchart.

How do you revert a pivotchart back to its original style?

Right-click on the pivotchart and select Reset to Match Style

With the pivotchart selected, click on Quick Layout and pick a new layout.

Click Control Z until you finally undo the pivotchart changes

Correct! You revert a pivotchart back to its original style by right-clicking on it and selecting Reset to Match Style.

Incorrect, choosing a new layout from Quick Layout does not guarantee that you will reset your pivotchart back to its original style.

Incorrect, if you keep undoing (control +z) your work, you will undo all your other work as well. This is not the best way to reset your pivotchart style.

{"name":"MASTERING EXCEL PIVOTTABLES - SECTION 05 REVIEW QUIZ", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Basics of Tax Course, What is your full name?, What color is an orange?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}