What is the correct tool for automating repeated data import and cleaning?
- A Power Query
- B A recorded VBA macro
- C Manual copy and paste
- D Conditional formatting
Answer
Power Query
Power Query is more maintainable than VBA for this task, works in Excel Online contexts VBA cannot, and documents its own steps.





