Module 6 -Quiz Power Query

What is Power Query used for in Excel? *

Formatting cells

Importing, transforming, and combining data

Creating pivot tables

Generating random data

How do you open Power Query in Excel? *

Home > Power Query

Data > Get & Transform Data

Insert > Power Query Tools

View > Query

Which file types can you import into Power Query? *

Excel files

CSV files

Web data

All of the above

Which feature removes duplicate rows in Power Query? *

Remove Duplicates

Delete Rows

Sort & Filter

Data Validation

How do you combine data from multiple sources in Power Query? *

Use the Merge or Append queries feature

Copy and paste data

Use the CONCATENATE function

Create a new worksheet