1.When Excel creates a PivotChart it uses the current PivotTable settings - if you want to change that data you might use

A. Insert PivotTable

B. Insert Function

C. PivotTable Field List

D. Filter Connections

2. When creating a pivot table, you should use a new worksheet because _____.

A. pivot tables only work in new worksheets B. Excel aggregates and consolidates data best in new worksheets C. separating the pivot table from the original dataset will prevent accidental deletions of the original dataset D. duplicate values are easily identified in new worksheets

3

To create a new Conditional Formatting Rule, _____.

A. convert the cell to a Range B. select any cell in the table and then click New Rule in the Tools group C. click in a cell and on the Home tab, and click the Cell Styles arrow in the Cells group D. click Conditional Formatting from the Cell Styles group and select New Rule