Lego Blocks Quiz - 10 Key Operations
Quiz by Siraj Samsudeen
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
37 questions
Show answers
- Q1in the kitchen analogy for PowerQuery, the Query List can be compared toIngredientsCooking CounterRecipeLive Counter30s
- Q2in the kitchen analogy for PowerQuery, Applied Steps can be compared toRecipeLive CounterCooking CounterIngredients30s
- Q3in the kitchen analogy for PowerQuery, Outputting to PowerPivot Data Model can be compared toLive CounterCustomerCooking CounterRecipe30s
- Q4Which operation does not make sense when 2 files are involved?MergeI Don't KnowAppendUnpivot30s
- Q5You want to combine employee masters from 2 different subsidiaries - you will use?SummarizeI Don't KnowAppendMerge30s
- Q6You receive 2 different versions of billing data in 2 files - which operation will you use to combine the files before applying the 'Remove Duplicates' operationAppendMergeAppend or Merge - both can be used depending on the type of output we want to produceI Don't Know30s
- Q7You 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?I Don't KnowUnpivotMergeSummarize/Group by30s
- Q8You 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?MergeAppendSummarizeI Don't Know30s
- Q9You 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?AppendSummarizeMergeI Don't Know30s
- Q10When you remove Duplicates in PQ Editor, you are given the option to select the column that define a DuplicateI Don't KnowTRUEFALSE30s
- Q11In PowerQuery, if you click on Remove Duplicates while you are in any cell, then the Duplicates are found inYou will get a prompt to select the columnsOnly in the current columnIn the entire TableI Don't Know30s
- Q12You have an Excel workbook with 3 sheets of similar data that you want to combine. Which operation will you use?AppendMergeI Don't KnowSummarize30s
- Q13You 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?Front Door - Open the Excel and bring each sheet one by oneI Don't KnowBack Door - Go to PQ Editor, then use the Option to bring an Excel sheet30s
- Q14You 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?Open the Excel and then bring each sheet into the PQ as a Table/RangeOpen a new Excel and bring this excel as an external fileI Don't Know30s
- Q15You 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?I Don't KnowOpen the Excel and then bring each sheet into the PQ as a Table/RangeOpen a new Excel and bring this excel as an external file30s