Check your knowledge

1.

What is the main purpose of using Power Query?

To build relationships to use in formulas

To clean and transform data to use with data models

To display information

To replace pivot tables

2.

Which of the following data sources can Power Query connect to?

Excel

CSV

Folders

All of the above

3.

Which of the following selections isn't one of the five key areas of the Power Query Editor window?

Queries pane

Preview

Conditional column

Query settings

4.

What language is used within the Power Query formula bar and is used to create custom columns?

MDX

DAX

M

SQL

Answer the following questions to see what you've learned.