Power Query

3. The "T" in ETL stands for:
4. The button you press when you have finished defining your flow.
7. To combine two queries, in the style of a VLOOKUP.
12. When we don't want to show the result of the query, we pick "Only _________"
14. Besides Excel, another MS tool where you use Power Query.
15. To combine two queries, one on top of the other.
16. Keyboard shortcut to jump into Power Query.

1. When in the main Excel window, press this to open the panel that shows all queries.
2. Create a new query starting from the final state of this one.
5. To read MULTIPLE Excel files from a SharePoint, we use "Get data from _____"
6. Create a copy of the query.
8. When we want to see the whole data set, we "Load to ___"
9. The name of a data flow in Power Query.
10. To read a SINGLE Excel file in a SharePoint, we use "Get data _____"
11. The button you press to start working with Power Query.
13. Append multiple data sets defined in a list or folder.