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"