1. Since Ribbon no longer provides commands for consolidatingdata, how can you access the Pivot Table and Pivot Chart Wizard?Select an answer:

1. Press Ctrl, then D, and then P.
2. Press Ctrl, then P, and then W.
3. Press Alt, then D, and then P.
4. Press Alt+P simultaneously, and then press D.

2. How can you most easily create a Pivot Table from externaldata if you cannot import the data directly as an Excel table?Select an answer:

1. Insert a Pivot Table from Insert on the Ribbon, click Use anexternal data source, and then click New Worksheet.
2. Use Insert on the Ribbon to create a Pivot Table, click Use anexternal data source > Choose connection, and then navigate tothe data source.
3. Convert the data to your most recent version of Excel, thenemail the table to yourself and create the table from there.
4. Use Insert on the Ribbon to create a Pivot Table, click Use andexternal data source > Choose connection, and then clickAdd.

3. When would you click Defer Layout Update in the FieldsArea? Select an answer:

1. when you have a large dataset, and you want to schedule a timefor all changes to be updated
2. when you want Excel to automatically update all changes at thedefault time set in Excel
3. when your dataset is so large, it is taking a long time toupdate changes
4. when you find it easier to update your Pivot Tables by simplyrefreshing them