MASTERING EXCEL PIVOTTABLES - SECTION 06 REVIEW QUIZ

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

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?

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?

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.