Pivot Tables
When selecting a cell, what happens after creating a conditional formatting rule?
A formatting options action button is shown beside the cell.
Under which category on the Excel Options dialog can you create a custom list?
Advanced Category
Since the PivotTable wizard is not currently on the contextual tabs, what key combination do you use to load the wizard?
Alt+D+P
If you want to view data by week, where should you drag the Week field in the PivotChart Fields dialog box?
Axis
If you are using the Value Filters from the Row Labels dropdown, which option would you most likely use for values that are within a range?
Between
You can include a summary to a table by selecting:
Total Row from the Design contextual tab .
How do you create a PivotTable after clicking a cell in the data set?
Select PivotTable from the Insert contextual tab.
How can you make alternate rows have different colors?
Select the Banded Rows checkbox from the Design tab.
An alternative to using vlookup formulas is to create relationships between tables.
TRUE
PivotTables enable you to change the structure of your data to emphasize different aspects of that data.
TRUE
To pivot a pivot chart, drag the fields between the Legend and Axis areas on the PivotChart Fields dialog.
TRUE
When creating a new slicer style, you can set it as the default for the current document.
TRUE
With calculated fields, you can create custom fields to summarize the PivotTable data using a formula.
TRUE
You can change the order in which the conditional format rules are applied.
TRUE
You can hide and show the Field Headers of the PivotTable from the Analyze contextual tab.
TRUE
You can set print options for printing a PivotTable using the Options button on the Analyze contextual tab.
TRUE
Which area can you use to drag fields between?
Values, Columns, Filters
Select the option that helps you run a macro.
assigning a macro to a shape, adding a quick access toolbar button, using a macro dialog box
What is the shortcut that allows you to select multiple items on the slicer?
ALT+S
What is the keyboard shortcut for accessing the Design contextual tab?
ALT+J+Y
You can manage the relationships between tables using the Relationships button on the Design contextual tab.
False
Where can you choose the type of calculation that you can use to summarize the data from the selected field?
Field Settings dialog
When removing the Month field from the body of the PivotTable, what is the associated property that got changed in the macro's Visual Basic code?
Orientation
After selecting the entire PivotTable, where can you define the print area?
Page Layout contextual tab -> Print Area
When applying the scope of the conditional format, which option includes the subtotals and grand totals?
all cells showing Sum of Revenue values
After creating a few macros, how can you add them to the quick access toolbar?
by clicking on Customize Quick Access Toolbar" -> More Commands"
