ch 10

PivotTable Tools Analyze tab

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

Refresh

To update a Power Query Editor, choose:

Filter

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

excel options dialog box

available add-ins for excel are found in the:

primary columnn

the create relationship dialog box identifies a table and a related table; the related table has a:

M language

the language that is specific to power query is:

view tab

to display the entire code for a power query, click the advanced editor button in the advanced group of the: ?

named set

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

key performance indicator

which depicts how a value compares to a measure?

data model

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

Power Pivot

a com add-in that enables you to use millions of records in the data model for a pivot table is a(n) quizlet

Query

a combo of instructions, filters, & formulas that establishes a connection to and displays data is a:

IF statement

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

XML

a file format that is designed for exchanging data on the web is called: in One Drive?

custom column

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