1 What is the primary function of Power Query in Excel?
a) To create charts and graphs
b) To import, clean, and transform data from various sources
c) To perform complex calculations
d) To format cells and ranges
Answer: b) To import, clean, and transform data from various sources
2 How do you access Power Query in Excel?
a) Data Tab > Get Data
b) Home Tab > Query Tools
c) Formulas Tab > Power Query
d) Data Tab > Power Query
Answer: a) Data Tab > Get Data
3 Which of the following is NOT a data source option available in Power Query?
a) Web
b) XML
c) JSON
d) PDF
Answer: d) PDF
4 What feature in Power Query allows you to filter data based on specific criteria?
a) Filter Rows
b) Group By
c) Merge Queries
d) Append Queries
Answer: a) Filter Rows
5 How can you combine data from multiple tables into a single table using Power Query?
a) Use the “Merge Queries” feature
b) Use the “Append Queries” feature
c) Use the “Group By” feature
d) Use the “Sort” feature
Answer: b) Use the “Append Queries” feature
6 What does the “Group By” feature in Power Query do?
a) Combines rows based on common values and performs aggregations
b) Filters rows based on specified criteria
c) Merges data from multiple tables
d) Sorts data in ascending or descending order
Answer: a) Combines rows based on common values and performs aggregations
7 How can you remove duplicate rows from a dataset in Power Query?
a) Use the “Remove Duplicates” feature
b) Apply a filter for unique values
c) Use the “Group By” feature with aggregation
d) Use the “Sort” feature and manually delete duplicates
Answer: a) Use the “Remove Duplicates” feature
8 Which option in Power Query allows you to split a column into multiple columns based on delimiters?
a) Split Column
b) Merge Columns
c) Group By
d) Filter Rows
Answer: a) Split Column
9 What does the “Transform” tab in Power Query allow you to do?
a) Change data types, split columns, and apply transformations to data
b) Import data from external sources
c) Export transformed data to a new file
d) Create visualizations from data
Answer: a) Change data types, split columns, and apply transformations to data
10 How do you load the transformed data from Power Query into an Excel worksheet?
a) Use the “Close & Load” option
b) Use the “Export” feature
c) Copy and paste the data manually
d) Save the Power Query as a separate file
Answer: a) Use the “Close & Load” option