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