WorksheetsPowerQ Teaser
Total questions: 15
Worksheet time: 8mins
To combine two queries one on top of the other, _____ queries is used.
Merging
Combining
Joining
Appending
Splitting of column can be done on the basis of ____
Space
Hyphen
Commas
All Delimiters
The steps used in transformation of a query are known as:
Applied Steps
Macros
Additional Steps
Record of Steps
Which function is used to create a calculated column or field in Power Query?
DAX
Conditional Functions
Database Functions
None of the options
How do you filter out a value in a query?
Highlight the column ⇒ press Ctrl + F ⇒ uncheck the value to filter out
Right click on the column header ⇒ Filter Rows ⇒ uncheck the value to remove
Click on the arrow to the right of the column header and uncheck the value to filter out
None of the above
What is the difference between a "Power" Pivot Table and a regular Pivot Table?
"Power" PivotTables allow you to analyze data across multiple tables and sources
"Power" Pivots can analyze much larger data sets (>1mm rows)
"Power" PivotTables allow you to create dynamic calculated measures using DAX
All of the above
Which is Power Query Workflow?
Get data & Edit
Get data & Edit & Close & Load to
Edit & Close & Load to
Edit
What steps is to make connections to data sitting in the cloud, in a service, or locally?
Connect
Share
Combine
Transform
_______allows you to import data from many different sources and then clean, transform and reshape your data as needed.
Power Query
Power Pivot
Conditional Formatting
Macros
Use of Transform Ribbon in Power Query is______.
Help to modify & make changes in the original column only
Help to modify & make changes in the data by adding a new column
Help to extract data from a database
None of these
Which three tabs in the Query Editor contain data shaping and transformation tools?
Home, Transform, Add Column
Transform, Load, Add Column
Load, Transform, Analyze
Load, Design, Analyze
TRUE or FALSE: The Query Editor "Transform" tools overwrite the existing values in a column
True
False
What is the purpose of Power Query?
To analyze data across multiple tables and sources
To import and transform data from various sources
To create dynamic calculated measures using DAX
To create pivot tables and perform data shaping
Which tab in the Query Editor is used to add new columns?
Home
Transform
Load
Analyze
What is the purpose of the Transform ribbon in Power Query?
To modify and make changes in the original column only
To modify and make changes in the data by adding a new column
To extract data from a database
To apply conditional formatting to the data
