What is the recommended way to create a new PivotTable style that is close to an existing
Question:
What is the recommended way to create a new PivotTable style that is close to an existing style?
Select an answer:
Duplicate the existing style and then Modify the new style.
Apply the existing style to your PivotTable and then change the PivotTable cells' formatting.
Write down the existing style's settings and use them as the base for the new style.
Modify the existing style.
1
Which currency symbols are available for the Currency and Accounting number formats?
Select an answer:
U.S. dollars, British pounds, and euros
U.S. dollars
Every currency symbol is available.
The available currency symbols depend on your local settings.
2
Why might your PivotTable include values that were NOT part of a data list you meant to use to create the PivotTable?
Select an answer:
The extra values were left over from the most recent PivotTable and will disappear when the PivotTable is refreshed.
The extra values were stored on another worksheet in the workbook where you created the PivotTable.
The extra values were in a row or column next to the data list.
The extra values were stored elsewhere on the worksheet that contains your data list.
3
If you have the Product Category and Sales Region fields in the Rows area in that order, how will the first set of PivotTable's results be organized?
Select an answer:
A row with sales by Sales Region for the first Product Category.
A column with sales by Sales Region for the first Product Category.
A row with sales by Product Category for the first Sales Region.
A column with sales by Product Category for the first Sales Region.
4
Why would you use Data Bars with a Pivot Table?
Select an answer:
to highlight the values of data in a cell
to horizontally display the relative magnitude of values in a cell
to highlight the relative magnitude of values in a cell
to horizontally display the values of data in a cell
5
Why would you use Data Bars with a Pivot Table?
Select an answer:
to highlight the values of data in a cell
to horizontally display the relative magnitude of values in a cell
to highlight the relative magnitude of values in a cell
to horizontally display the values of data in a cell
6
When would you click Defer Layout Update in the Fields Area?
Select an answer:
when you have a large dataset, and you want to schedule a time for all changes to be updated
when your dataset is so large, it is taking a long time to update changes
when you find it easier to update your Pivot Tables by simply refreshing them
when you want Excel to automatically update all changes at the default time set in Excel
7
Which comparison operator would you use to determine if a salesperson met or exceeded their goal?
Select an answer:
greater than or equal to
less than
greater than
less than or equal to
8
How can you most easily create a Pivot Table from external data if you cannot import the data directly as an Excel table?
Select an answer:
Use Insert on the Ribbon to create a Pivot Table, click Use and external data source > Choose connection, and then click Add.
Insert a Pivot Table from Insert on the Ribbon, click Use an external data source, and then click New Worksheet.
Convert the data to your most recent version of Excel, then email the table to yourself and create the table from there.
Use Insert on the Ribbon to create a Pivot Table, click Use an external data source > Choose connection, and then navigate to the data source.