What is Power Query primarily used for?
- A Connecting to sources and transforming data through repeatable, refreshable steps
- B Creating charts
- C Writing macros
- D Formatting cells
Answer
Connecting to sources and transforming data through repeatable, refreshable steps
Every step is recorded, so a monthly manual clean-up becomes a refresh. This is the key distinction from doing the same work with formulas.





