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 required of source data for a PivotTable to work correctly?

  1. A Flat data with one header row, no blank rows and no merged cells
  2. B Data sorted alphabetically
  3. C At least 1,000 rows
  4. D Data on a separate workbook
Answer

Flat data with one header row, no blank rows and no merged cells

Cross-tabulated data with months as separate columns must be unpivoted first, which Power Query does easily.

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