Question 1

1. You are given a CSV file with thousands of rows. What is the most efficient method to clean and transform this data in Excel?

Accepted Answer

Use Power Query to load, clean, and transform the data

Answer

Import the data into Access and run SQL queries

Answer

Manually edit each row

Answer

Use Excel formulas for each column

Question 2

2. How can you combine data from multiple Excel sheets into a single table using Power Query?

Accepted Answer

Use the "Append Queries" feature in Power Query

Answer

Copy and paste data manually into one sheet

Answer

Use VLOOKUP to combine data

Answer

Create a Pivot Table to consolidate the data

Question 3

3. A client provides you with a web URL containing stock prices that need to be analyzed daily. Which Power Query feature will automate this process?

Accepted Answer

Web scraping with Power Query

Answer

Using macros in Excel

Answer

Exporting data to CSV and importing daily

Answer

Manual data entry every day

Question 4

4. After transforming data in Power Query, what is the next step to make the data usable in Excel?

Accepted Answer

Load the data back to Excel using "Close & Load"

Answer

Use the "Refresh All" button in Excel without closing Power Query

Answer

Save the Power Query steps in a text file

Answer

Copy the transformed data manually

Question 5

5. You need to merge data from two tables with different column names that represent the same data. How would you handle this in Power Query?

Accepted Answer

Use the "Merge Queries" feature and select the appropriate matching columns

Answer

Rename the columns in Excel before merging

Answer

Combine the tables manually using copy-paste

Answer

Use a complex array formula

Question 6

6. During a data transformation, you realize that some rows are duplicated. How would you efficiently remove duplicates using Power Query?

Accepted Answer

Use the "Remove Duplicates" option in Power Query

Answer

Filter the duplicates and delete them one by one

Answer

Manually delete the duplicate rows

Answer

Use Excel's "Remove Duplicates" feature

Question 7

7. You are tasked with creating a monthly sales report. How can Power Query help in automating this recurring task?

Accepted Answer

Set up a query to automate data import and transformation, and refresh it monthly

Answer

Manually enter data and use Pivot Tables

Answer

Use Excel's "Record Macro" feature

Answer

Create a new Excel file each month

Question 8

8. While working with Power Query, you need to extract a specific date format from a mixed text string. Which transformation should you apply?

Accepted Answer

Use the "Extract" transformation to isolate the date

Answer

Manually extract the date using Find and Replace

Answer

Use conditional formatting to highlight the date

Answer

Use the MID and DATE functions in Excel

Question 9

9. A dataset has various null values scattered across different columns. What is the best approach to handle these in Power Query?

Accepted Answer

Use the "Replace Values" feature to fill or remove nulls

Answer

Filter out all rows with null values

Answer

Manually search and replace each null value

Answer

Delete the columns containing null values

Question 10

10. You need to create a dynamic report that updates when the source data changes. How can Power Query be used to achieve this?

Accepted Answer

Create a query that automatically refreshes with the source data

Answer

Manually update the report each time

Answer

Export data to a separate Excel file for each update

Answer

Use static charts and tables

Related quizzes

Related quizzes