MASTERING EXCEL PIVOTTABLES - SECTION 06 REVIEW QUIZ

Before printing a pivottable, what tab do you use to turn off the Expand/Collapse buttons?

Design tab

Insert tab

Analyze tab

Incorrect, the Design tab is not the place to turn off the Expand/Collapse buttons when printing. It is the tab you visit to manage your pivotable layout, style options, and styles.

Incorrect, the Insert tab is not the place to turn off the Expand/Collapse buttons when printing. It is the tab you visit to add pictures, shapes, add-ins, charts, filters, text, symbols, and more.

Correct! The analyze tab is the correct tab when you want to turn off the Expand/Collapse buttons before printing.

Can you print a pivottable by itself?

Yes

Only when using Windows 10

That's incorrect, you definitely can print out a pivottable by itself by clicking in it, clicking the ANALYZE tab, clicking SELECT and choosing ENTIRE PIVOTTABLE.

Correct! You can print out a pivottable by itself by clicking in it, clicking the ANALYZE tab, clicking SELECT and choosing ENTIRE PIVOTTABLE.

No, that' incorrect. You're operating system has nothing to do with printing pivottables.

How would you print each year of a pivottable on a different page?

Click in the YEAR field, and on the ANALYZE tab, click on FIELD SETTINGS and click the LAYOUT AND PRINT tab, and turn on INSERT PAGE BREAK AFTER EACH ITEM

It's not possible to do that.

Highlight each year separately and select Control P each time a year is selected.

Correct! To print out each year of a pivottable on a separate page, click in the YEAR field, and on the ANALYZE tab, click on FIELD SETTINGS and click the LAYOUT AND PRINT tab, and turn on INSERT PAGE BREAK AFTER EACH ITEM.

Incorrect. It is possible to print each year of a pivottable on a different page. Just click in the YEAR field, and on the ANALYZE tab, click on FIELD SETTINGS and click the LAYOUT AND PRINT tab, and turn on INSERT PAGE BREAK AFTER EACH ITEM.

Incorrect. This will only result in you printing the entire pivottable.

{"name":"MASTERING EXCEL PIVOTTABLES - SECTION 06 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"}