Monday to Friday
9am to 5pm
email
info@cadtraining.com.my // info@caddesignschool.com
phone
03-80630414 // 012-2737190
location
3rd Floor, 27 Jalan Puteri 4/6, Bandar Puteri, 47100 Puchong, Selangor
Power Query Quiz
Don’t know where your level of Power Query knowledge is?
Try out our quiz and find out today!
1 / 15
Which option in Power Query allows you to visualize summarized data in Excel?
2 / 15
When would you typically use the “Use First Row as Header” option in Power Query?
3 / 15
What does ETL stand for in the context of Power Query?
4 / 15
Which Power Query feature allows you to merge columns from different tables based on a common key?
5 / 15
How is conditional logic implemented in Power Query’s M language for transforming data?
6 / 15
What is the primary programming language used in Power Query for advanced data manipulation?
7 / 15
In Power Query, what does the “Transpose” operation allow you to do?
8 / 15
Which feature in Power Query enables you to combine the values of two or more columns into a single column?
9 / 15
How does the “Use First Row as Header” option affect the data in Power Query?
10 / 15
Which Power Query transformation allows you to convert multiple columns into rows?
11 / 15
Which operation in Power Query enables you to combine rows from different tables with identical headers?
12 / 15
When using Power Query, which step comes first in the ETL process?
13 / 15
What does the “Pivot Column” feature in Power Query enable you to do?
14 / 15
Which transformation in Power Query allows you to convert a single column into multiple columns based on its values?
D) Merge Columns
15 / 15
In Power Query, what does the “Merge” operation allow you to do?
Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.
Thank you
Restart quiz