Excel – Power Query Basics
Practice Excel Power Query interview questions covering data import, transformation, and refresh. Answer questions and receive feedback on approach. Ideal for data analyst interview prep. First 2 questions are free with full feedback.
- Level Intermediate
- Questions 12
Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.
Sample excel – power query basics interview questions
Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.
-
What is Power Query?
What a strong answer includes
Tool for importing and transforming data.
-
How do you import data with Power Query?
What a strong answer includes
Uses Get Data.
-
What is the Power Query Editor?
What a strong answer includes
Interface for transform steps.
-
How do you remove columns in Power Query?
What a strong answer includes
Selects and removes.
-
How do you filter rows?
What a strong answer includes
Uses filter dropdowns.
-
What is the benefit of Power Query over manual cleanup?
What a strong answer includes
Steps are repeatable and refreshable.