Quizalize logo
placeholder image to represent content

I Bet You Don't Know All These Power Query Tricks

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
    Which function can be used to promote headers without using the promoted headers step?
    Promote Headers
    Change Type
    Excel.Workbook(True)
    Data.Get()
    30s
  • Q2
    How can you extract an intermediary step from a query and convert it into a separate query?
    D. Use the promote headers function and then reference the desired step.
    C. There is no way to extract intermediary steps in Power Query.
    A. Convert the entire query into a record, then reference the desired step using its position in the record.
    B. Edit the query by duplicating the desired step.
    30s
  • Q3
    Which method avoids hardcoding column names when dynamically expanding tables using the table.combine function?
    A. Convert all tables into a list before using table.combine.
    B. Use the expand function multiple times.
    C. Manually reference each table by name in the table.combine function.
    D. Dynamically expanding tables is not possible in Power Query.
    30s
  • Q4
    What is the purpose of using projections in Power Query?
    A. To select specific columns from a table in a different way than using table.selectcolumns.
    B. To promote headers in a table.
    D. Projections are not a feature in Power Query.
    C. To combine multiple tables.
    30s
  • Q5
    Which keyword can be used to get a list of all the queries in your Power BI instance?
    C. Get Power Query List
    A. Sections#
    D. List All Queries
    B. Queries()
    30s
  • Q6
    Which data types can be checked using the is keyword in Power Query?
    A. Numbers, Text, Lists, Records, and Tables.
    B. Only Numbers and Text.
    C. Only Text.
    D. The is keyword cannot be used for data type checks.
    30s
  • Q7
    What does the & operator do in Power Query when used with lists?
    C. Sorts two lists together.
    B. Subtracts one list from another.
    A. Combines two lists into a single list.
    D. The & operator cannot be used with lists.
    30s
  • Q8
    What does the & operator do in Power Query when used with tables?
    A. Combines two tables into a single table, but may result in a haphazard combination if the tables are not structured similarly.
    B. Subtracts one table from another.
    D. The & operator cannot be used with tables.
    C. Merges two tables based on a common column.
    30s
  • Q9
    Which of the following statements is true about using the sections# keyword in Power BI?
    B. It can be used to dynamically reference all queries and load them into Power BI.
    A. It works in Excel but not in Power BI.
    C. It can be used to edit existing queries in Power BI.
    D. The sections# keyword is not available in Power BI.
    30s
  • Q10
    What are two ways to extract an intermediary step from a query as mentioned in the video?
    A. 1. Convert the entire query into a record, then reference the desired step using its position in the record. 2. Use the meta keyword to store the desired step as metadata and then reference it in another query.
    C. By promoting the desired step using the promote headers function.
    A. There is no way to extract intermediary steps in Power Query.
    B. By duplicating the desired step in the query editor.
    30s

Teachers give this quiz to your class