Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/37
Score 0
in the kitchen analogy for PowerQuery, the Query List can be compared to
30
Ingredients
Cooking Counter
Recipe
Live Counter
Q 2/37
Score 0
in the kitchen analogy for PowerQuery, Applied Steps can be compared to
30
Recipe
Live Counter
Cooking Counter
Ingredients
37 questions
Q.
in the kitchen analogy for PowerQuery, the Query List can be compared to
1
30 sec
Q.
in the kitchen analogy for PowerQuery, Applied Steps can be compared to
2
30 sec
Q.
in the kitchen analogy for PowerQuery, Outputting to PowerPivot Data Model can be compared to
3
30 sec
Q.
Which operation does not make sense when 2 files are involved?
4
30 sec
Q.
You want to combine employee masters from 2 different subsidiaries - you will use?
5
30 sec
Q.
You receive 2 different versions of billing data in 2 files - which operation will you use to combine the files before applying the 'Remove Duplicates' operation
6
30 sec
Q.
You have budget data at a summary level per division per month. You have the expenditure per Payment - what operation will you use on the expenditure data to compare budget vs actuals?
7
30 sec
Q.
You have budget data at a summary level per division per month. You have the expenditure per Payment - what operation will you use to combine the 2 files?
8
30 sec
Q.
You start with an Employee Master - you have to combine data from Department Master and also add new employees information from another file. Which operation should be done first?
9
30 sec
Q.
When you remove Duplicates in PQ Editor, you are given the option to select the column that define a Duplicate
10
30 sec
Q.
In PowerQuery, if you click on Remove Duplicates while you are in any cell, then the Duplicates are found in
11
30 sec
Q.
You have an Excel workbook with 3 sheets of similar data that you want to combine. Which operation will you use?
12
30 sec
Q.
You have an Excel workbook with 3 sheets of similar data that you want to combine. Which is the better way bring the data into PQ?
13
30 sec
Q.
You have an Excel workbook with 3 sheets - you want to bring them all into PQ. What is the meaning of bringing this Excel through the FRONT door?
14
30 sec
Q.
You have an Excel workbook with 3 sheets - you want to bring them all into PQ. What is the meaning of bringing this Excel through the BACK door?
15
30 sec
Q.
You have an Excel workbook with 3 sheets - you want to bring them all into PQ and load them as connection only. What is a faster ?
16
30 sec
Q.
You have an Excel workbook with 3 sheets - You want to bring the data into PQ Editor so that Table Names are automatically created for you based on Sheet Names. Which approach?
17
30 sec
Q.
You have an employee master which you need to sort by two possible lists and output in 2 sheets - one by State & City and another by Dept & Salary - which operation makes more sense?
18
30 sec
Q.
You have an employee master and you want to split it into 2 sheets - Male and Female Employees. But you want the structure of these 2 sheets to be exactly the same - LATER if changes are made to the output of one sheet, it should NOT be missed out in the other sheet. So, which operation makes more sense?
19
30 sec
Q.
Fill in the blank -> When you ---, all the steps in the Query are copied into the new Query and you can make changes to the new Query and the old Query independently.
20
30 sec
Q.
You have referenced the Employee Master query in another query called 'New Query'. Now you have added 2 more steps to the Employee Master Query. So, what happens?
21
30 sec
Q.
You have referenced the Employee Master query in another query called 'New Query'. Now you have added a new sort in the Employee Master Query. So, what happens?
22
30 sec
Q.
Which view will give you a pictorial view of your queries and how they are connected to each other?
23
30 sec
Q.
Summarize/Group by in PowerQuery is exactly the same as
24
30 sec
Q.
Summarize/Group by produces a unique list of the columns you specify in the Group by List
25
30 sec
Q.
You want to change the Join Date to Join Year without losing the original column. Which Menu Bar will you choose for choosing the relevant Date operation?
26
30 sec
Q.
Power Query uses the order of column when appending queries.
27
30 sec
Q.
You have 3 files you want to merge. But a column name has been changed in only one file. So, how do you combine them into a single column?
28
30 sec
Q.
Which operation is similar to Excel VLOOKUP?
29
30 sec
Q.
Which operation is similar to copying and pasting data at the bottom of an existing range?
30
30 sec
Q.
You are joining Employee Master with Dept Table. But for one Dept Code, there are 2 rows in the Dept Table. What will PQ do?
31
30 sec
Q.
You have an Excel in which Month are listed across (as columns). You want them as rows. Which operation makes sense?
32
30 sec
Q.
You have an Excel with 2 columns - Amount Type and Amount. Amoutn Type column has 2 values - Budget and Actuals. Now you want to have Budget and Actuals as columns columns - which operation makes sense?
33
30 sec
Q.
In Data Profiling Pane, both Distinct and Unique mean the same.
34
30 sec
Q.
Fill in the blank -> PQ Editor displays --- when there is NO value in a Numeric column
35
30 sec
Q.
Fill in the blank -> PQ Editor displays --- when there is NO value in a Text/String column
36
30 sec
Q.
For a column that contains an ID like Employee Number or Social Security Number