Quizalize logo
placeholder image to represent content

Power Query

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

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

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    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?
    Import the data into Access and run SQL queries
    Use Power Query to load, clean, and transform the data
    Manually edit each row
    Use Excel formulas for each column
    40s
  • Q2
    2. How can you combine data from multiple Excel sheets into a single table using Power Query?
    Copy and paste data manually into one sheet
    Use the "Append Queries" feature in Power Query
    Use VLOOKUP to combine data
    Create a Pivot Table to consolidate the data
    40s
  • Q3
    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?
    Web scraping with Power Query
    Using macros in Excel
    Exporting data to CSV and importing daily
    Manual data entry every day
    40s
  • Q4
    4. 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 Query
    Save the Power Query steps in a text file
    Load the data back to Excel using "Close & Load"
    Copy the transformed data manually
    40s
  • Q5
    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?
    Use the "Merge Queries" feature and select the appropriate matching columns
    Rename the columns in Excel before merging
    Combine the tables manually using copy-paste
    Use a complex array formula
    40s
  • Q6
    6. 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 Query
    Filter the duplicates and delete them one by one
    Manually delete the duplicate rows
    Use Excel's "Remove Duplicates" feature
    40s
  • Q7
    7. 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 Tables
    Use Excel's "Record Macro" feature
    Create a new Excel file each month
    Set up a query to automate data import and transformation, and refresh it monthly
    40s
  • Q8
    8. 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 Replace
    Use conditional formatting to highlight the date
    Use the "Extract" transformation to isolate the date
    Use the MID and DATE functions in Excel
    40s
  • Q9
    9. 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 values
    Manually search and replace each null value
    Use the "Replace Values" feature to fill or remove nulls
    Delete the columns containing null values
    40s
  • Q10
    10. 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 data
    Manually update the report each time
    Export data to a separate Excel file for each update
    Use static charts and tables
    40s

Teachers give this quiz to your class