421

Monday to Friday

9am to 5pm

FREE Repeat Classes

COURSES
SCHEDULE
- Course Dates
ABOUT
FREE RESOURCES

email

info@cadtraining.com.my // info@caddesignschool.com

phone

0380630414___01173052587__014-6491168

location

3rd Floor, 27 Jalan Puteri 4/6, Bandar Puteri, 47100 Puchong, Selangor

Power Query Quiz

Test your Power Query knowledge with our Power Query quiz today!

0%

Power Query Quiz

Don’t know where your level of Power Query knowledge is?

Try out our quiz and find out today!

1 / 15

When using Power Query, which step comes first in the ETL process?

a) Transform

b) Load

c) Extract

d) Connect

2 / 15

Which Power Query transformation allows you to convert multiple columns into rows?

a) Unpivot Columns

b) Pivot Columns

c) Append Tables

d) Merge Tables

3 / 15

Which Power Query feature allows you to merge columns from different tables based on a common key?

a) Append Queries

b) Merge Queries

c) Combine Queries

d) Merge Columns

4 / 15

Which transformation in Power Query allows you to convert a single column into multiple columns based on its values?

A) Unpivot Columns
B) Pivot Columns
C) Split Column

D) Merge Columns

a) Unpivot Columns

b) Pivot Columns

c) Split Column

d) Merge Columns

5 / 15

Which operation in Power Query enables you to combine rows from different tables with identical headers?

a) Unpivot Columns

b) Pivot Columns

c) Append Tables

d) Merge Tables

6 / 15

What does the “Pivot Column” feature in Power Query enable you to do?

a) Create a new column based on existing column values

b) Unpivot a column

c) Convert columns into rows

d) Convert rows into columns based on column values

7 / 15

Which option in Power Query allows you to visualize summarized data in Excel?

a) Load to Table

b) Load to Pivot Table

c) Create Connection Only

d) Transform Data

8 / 15

How does the “Use First Row as Header” option affect the data in Power Query?

a) It removes the first row from the dataset

b) It promotes the first row as column headers

c) It applies transformations to the first row

d) It converts the first row into a separate table

9 / 15

What does ETL stand for in the context of Power Query?

a) Extract, Translate, Load

b) Extract, Transform, Load

c) Edit, Transform, Load

d) Extract, Transform, Link

10 / 15

How is conditional logic implemented in Power Query’s M language for transforming data?

a) Using the IF-THEN-ELSE function

b) Using the WHEN-THEN-ELSE function

c) Using the IF…ELSE statement

d) Conditional logic is not supported in Power Query

11 / 15

When would you typically use the “Use First Row as Header” option in Power Query?

a) When you want to filter the first row of your dataset

b) When the first row contains the column headers

c) When you want to merge multiple tables

d) When you want to unpivot columns

12 / 15

What is the primary programming language used in Power Query for advanced data manipulation?

a) Python

b) SQL

c) M Query Language

d) R

13 / 15

Which feature in Power Query enables you to combine the values of two or more columns into a single column?

a) Transpose

b) Merge Columns

c) Unpivot Columns

d) Pivot Columns

14 / 15

In Power Query, what does the “Transpose” operation allow you to do?

a) Convert rows into columns and columns into rows

b) Merge multiple tables into one

c) Filter rows based on specific criteria

d) Convert text to numbers

15 / 15

In Power Query, what does the “Merge” operation allow you to do?

a) Combine tables by stacking them vertically

b) Join tables based on common columns

c) Convert rows into columns

d) Split columns into multiple columns

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

View Our Courses Now

QUICK LINKS

Our Courses
About Us
Faq
Privacy Policy

CONTACT

Phone: 03-8063-0414

Email: info@caddesignschool.com

Cad Training Centre 3-27, Jalan Puteri 4/6,

Bandar Puteri, 47100 Puchong, Selangor, Malaysia

SOCIAL MEDIA

Facebook
LinkedIn
Instagram
YouTube

Skip to toolbar

About WordPress

Search

Power Query Quiz

Test your Power Query knowledge with our Power Query quiz today!

View Our Courses Now

Microsoft Excel (Basics - Advanced)

Dashboard, Power Pivot & Power Query

Visual Basics for Application (VBA)

Microsoft Power Business Intelligence (Power BI)

Financial Modelling

Financial Statement Analysis

Microsoft Excel
(Basics - Advanced)