What does the Data Model in Excel allow?
- A Relating multiple tables so one PivotTable can span them
- B Encrypting the workbook
- C Creating charts automatically
- 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.





