1. Which step is first in viewing all the conditional rules you have applied to a Pivot Table? Select an answer:

1. Open a new worksheet, then click any cell.
2. Click any Totals or Subtotals cell within the Pivot Table.
3. Click any cell on the worksheet outside of the Pivot Table.
4. Click any cell on the within the Pivot Table.

2. Why would you use Data Bars with a Pivot Table? Select an answer:

1. to horizontally display the relative magnitude of values in a cell
2. to horizontally display the values of data in a cell
3. to highlight the values of data in a cell
4. to highlight the relative magnitude of values in a cell

3. Your Pivot Table shows purchases for each quarter of 2019 for three products you buy. If you perform the operation in the Analyze to Show Report Filter Pages by category, what will you create? Select an answer:

1. three separate worksheets, one for each product category
2. three Pivot Tables, one for each product category, on the same worksheet
3. four separate worksheets, one for each quarter
4. four Pivot Tables, one for each quarter, on the same worksheet

4. Which function do "slicers" have in an Excel Pivot Table? Select an answer:

1. Slicers are limitations on filtering data in a Pivot Table.
2. Slicers are a deeper level filter applied to a filter.
3. Slicers are the way multiple fields are filtered through.
4. Slicers are a visual display of filters applied to a Pivot Table.