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 Power Query primarily used for?

  1. A Connecting to sources and transforming data through repeatable, refreshable steps
  2. B Creating charts
  3. C Writing macros
  4. 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.

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