Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the correct tool for automating repeated data import and cleaning?

  1. A Power Query
  2. B A recorded VBA macro
  3. C Manual copy and paste
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as