Chapter 10

A combination of instructions, filters, and formats that establishes a connection to and displays data is a:

Query

A file format that is designed for exchanging data on the web is called: in OneDrive?

e. XML

Calculated data that appears in the Power Query but it not a field in the source data is called a:

Custom Column

A collection of tables and queries in a workbook is called a:

Data Model

To display the entire code for a Power Query, click the advanced editor button in the advanced group of the:?

View Tab

Available Add-ins for excel are found in the:

Excel Options dialog box

The slicer tool creates an on-screen window. that acts as a(n):

Filter

A conditional column uses a(n) _____ to display new data in a query

IF statement

The Create Relationship dialog box identifies a Table and a Related Table; the Related Table has a:

Primary Column

Which depicts how a value compares to a measure?

Key Performance Indicator

The language that is specific to Power Query is:

M Language

To save a custom grouping or subset of items in a PivotTable, create a(n):

Named Set

To create a slicer, click the insert slicer button in the filter group on the:

PivotTable Tools Analyze Tab

A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n):

Power Pivot

To update a Power Query Editor, choose:

Refresh