Chapter Ten Flashcards
1
Q
Calculated data that appears in the Power Query but is not a field in the source data is called a:
A
Custom Column
2
Q
The language that is specific to Power Query is:
A
M Language
3
Q
A conditional column uses what to display new data in a query?
A
IF statement
4
Q
To save a custom grouping or subset of items in a PivotTable, create a:
A
Named Set
5
Q
What creates a visual filter for a field in a PivotTable?
A
Slicer Tool
6
Q
What is a column in which each data piece appears only once?
A
Key Field
7
Q
What is a visual representation for a column that has a measure?
A
Key Performance Indicator
8
Q
A file format that is designed for exchanging data on the web is called:
A
XML
