Question

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.

Answer 1

Answer 1 d

For viewing conditional formatting in pivot table we have to click in any cell in the pivot table then click conditional formating

Answer 2 d

Data bars add a horizontal bar in color showing the rlative strength of cell value.

Answer 3 a

The result will be displayed on three seprete worksheets on the same workbook, each displaying the individual product.

Answer 4 d

Slicer in a pivot table provide visual filters with the help of which the data can be filtered according to users needs.