Power Query
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q11. You are given a CSV file with thousands of rows. What is the most efficient method to clean and transform this data in Excel?Import the data into Access and run SQL queriesUse Power Query to load, clean, and transform the dataManually edit each rowUse Excel formulas for each column40s
- Q22. How can you combine data from multiple Excel sheets into a single table using Power Query?Copy and paste data manually into one sheetUse the "Append Queries" feature in Power QueryUse VLOOKUP to combine dataCreate a Pivot Table to consolidate the data40s
- Q33. 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?Web scraping with Power QueryUsing macros in ExcelExporting data to CSV and importing dailyManual data entry every day40s
- Q44. After transforming data in Power Query, what is the next step to make the data usable in Excel?Use the "Refresh All" button in Excel without closing Power QuerySave the Power Query steps in a text fileLoad the data back to Excel using "Close & Load"Copy the transformed data manually40s
- Q55. 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?Use the "Merge Queries" feature and select the appropriate matching columnsRename the columns in Excel before mergingCombine the tables manually using copy-pasteUse a complex array formula40s
- Q66. During a data transformation, you realize that some rows are duplicated. How would you efficiently remove duplicates using Power Query?Use the "Remove Duplicates" option in Power QueryFilter the duplicates and delete them one by oneManually delete the duplicate rowsUse Excel's "Remove Duplicates" feature40s
- Q77. You are tasked with creating a monthly sales report. How can Power Query help in automating this recurring task?Manually enter data and use Pivot TablesUse Excel's "Record Macro" featureCreate a new Excel file each monthSet up a query to automate data import and transformation, and refresh it monthly40s
- Q88. While working with Power Query, you need to extract a specific date format from a mixed text string. Which transformation should you apply?Manually extract the date using Find and ReplaceUse conditional formatting to highlight the dateUse the "Extract" transformation to isolate the dateUse the MID and DATE functions in Excel40s
- Q99. A dataset has various null values scattered across different columns. What is the best approach to handle these in Power Query?Filter out all rows with null valuesManually search and replace each null valueUse the "Replace Values" feature to fill or remove nullsDelete the columns containing null values40s
- Q1010. You need to create a dynamic report that updates when the source data changes. How can Power Query be used to achieve this?Create a query that automatically refreshes with the source dataManually update the report each timeExport data to a separate Excel file for each updateUse static charts and tables40s