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 does the Data Model in Excel allow?

  1. A Relating multiple tables so one PivotTable can span them
  2. B Encrypting the workbook
  3. C Creating charts automatically
  4. D Validating cell entries
Answer

Relating multiple tables so one PivotTable can span them

Power Pivot with the Data Model handles far more rows than a worksheet and compresses the data heavily.

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