MASTERING EXCEL PIVOTTABLES - SECTION 04 REVIEW QUIZ

Excel allows you to apply special formatting to your pivottables based on certain rules you define. What are these rules called?

Pivotcharts

Conditional Formatting

Formulas

Incorrect. A pivotchart is a tool that enables one to visualize a pivot table.

Correct, conditional formatting allows you to apply special formatting to your pivottables based on certain rules defined.

Incorrect. Formulas allow you to quickly make calculations and get totals of multiple cells, rows, or columns.

What is the quickest action to take if you need to change the number formatting for all REVENUE fields in your pivottable?

Right-click on any cell in your pivottable containing REVENUE, select Value Field Settings, and select Number Format

Click on each cell containing revenue and manually reformat each one

Click in your pivottable, then click FIELDS, ITEMS, and SETS in Analyze tab

Correct! The quickest way to change the number format for all REVENUE fields in your pivottable is to right-click on any cell in your pivottable containing REVENUE, select Value Field Settings, and select Number Format.

Incorrect, clicking on each cell containing revenue and manually reformatting each one is definitely not the quickest way to reformat the revenue fields.

Your answer is incorrect. Clicking FIELDS, ITEMS, and SETS in the Analyze tab will not allow you to reformat the revenue fields in your pivottable. The FIELDS, ITEMS, and SETS button is used for adding Calculated Fields, and other functions.

What tool allows you create a heat map in your pivottable where each cell uses a light to dark gradient to represent that values of your data?

Icon Sets

Format Painter

Color Scales

Incorrect. Icon Sets are used to add selected icons to cells in your pivottalbe, such as a green light, red light and yellow light.

Incorrect.The Format Painter function is used to apply a format (number, text, etc.) from one cell to other cells.

Correct! Color Scales allow you to apply a color gradient to a range of cells. The color indicates where each cell value falls within that range, hence making a great heat map.

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