MASTERING EXCEL PIVOTTABLES - FINAL EXAM | Take the Quiz

Identify how to manage a pivottable so it automatically updates when new data is added.

Summarize the pivottable

Turn your raw data into a table prior to creating a pivotable

Add banded rows to the pivottable

Insert a slicer

What method do you use to create a pivottable?

Select all rows and columns of the raw data: Control + Z

Right-click on the raw data; Select Insert

Insert tab: Table

Click within the raw data; Insert tab; Pivottable

Which Value Filter would apply to a pivotable if you wanted to only see values over $200,000?

Less Than Or Equal To

Top 10

Greater Than

Between

What should you eliminate from a dataset in order to construct a successful pivottable?

Extra spacing

Blank rows

Symbols

Banded rows

How do you create a pivottable from an external data source?

Insert tab; Pivottable; Use an External Data Source; Choose Connection

Insert tab; Pivottable; Select a table or range

Insert tab; Pivottable; Use this Worksheet's Data Model

Insert tab; Pivotchart; New worksheet

Identify which options listed below are available for displaying subtotals in a pivottable.

You can display subtotals at the top of a group

You can display subtotals at the bottom of a group

You can show no subtotals

All of the above

What's the real power of a pivottable?

The ability to add up totals of rows and columns

How easily you can dynamically change the view of the raw data in the table

How easy it is to format cells

Numbers

Identify the best way to quickly create a visually appealing pivottable.

Add Row Headers

Change the font sizes

Use Pivottable Styles menu

Use Conditional Formatting

How do you construct a trendline with a customized time period?

Right-click on the pivotchart and select Pivotchart Options

Double-click on the trendline; Trendline Options; Forecast

Double-click on the trendline; Trendline Options; Moving Average

You cannot customize a trendline's time period

Identify what pivottable filtering allows you to do.

Sort data

Count numbers

Remove duplicates

Customize values

Using VALUE FIELD SETTINGS in the ANALYZE tab, how can you format the numbers in a pivottable?

It's not unusual for a business to have pivottables with millions of rows and thousands of columns. What tool makes large pivottables more manageable by allowing you to decide when to update all changes made?

Data Validation

Defer Layout Update

Insert Timeline

Conditional Formatting

Which tool would you use to help make better decisions by representing data graphically in each cell?

A slicer

Data Bars

Fonts

Top/Bottom Rules

How do you isolate any part of a pivot table?

Use Control + F to find the data

Create another pivottable out of the data for comparison

Drill down into the data

Change the data source

Which data summary tool allows you to build custom fields within your pivottable that includes formulas?

List Formulas

Calculated fields

Grand totals

Slicers

Which button in the ANALYZE tab allows you to hide or show the Pivottable Fields pane?

Field List

Field Headers

+/- Buttons

Insert Slicer

Which value type under VALUE FIELD SETTINGS shows a cumulative value in a pivottable?

Average

% of Grand Total

Running Total In

Rank Smallest to Largest

Identify the quickest way to create a pivottable.

Use the FORMAT AS A TABLE tool

Use the RECOMMENDED CHARTS tool

Use the CONVERT TO RANGE tool

Use the RECOMMENDED PIVOTTABLES tool

Unlock and Upgrade

Remove all limits from your Quizzes

MASTERING EXCEL PIVOTTABLES - FINAL EXAM

More Quizzes