1. Since Ribbon no longer provides commands for consolidatingdata, how can you access the Pivot Table and...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Since Ribbon no longer provides commands for consolidatingdata, how can you access the Pivot Table and Pivot Chart Wizard?Select an answer:
- Press Ctrl, then D, and then P.
- Press Ctrl, then P, and then W.
- Press Alt, then D, and then P.
- 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:
- Insert a Pivot Table from Insert on the Ribbon, click Use anexternal data source, and then click New Worksheet.
- Use Insert on the Ribbon to create a Pivot Table, click Use anexternal data source > Choose connection, and then navigate tothe data source.
- Convert the data to your most recent version of Excel, thenemail the table to yourself and create the table from there.
- 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:
- when you have a large dataset, and you want to schedule a timefor all changes to be updated
- when you want Excel to automatically update all changes at thedefault time set in Excel
- when your dataset is so large, it is taking a long time toupdate changes
- when you find it easier to update your Pivot Tables by simplyrefreshing them
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date: