Which of the following is true of Power Pivot?
A)If you don't have a Data Model in your Excel file,you won't see any data in the Power Pivot window.
B)The data you see in the Power Pivot window can be a mix of data in the Data Model and data not in the Data Model.
C)The tables you see in the Power Pivot window have necessarily been related through their primary and foreign keys; otherwise,the tables wouldn't appear in the Power Pivot window.
D)The only way to relate tables that have not yet been related is through the Power Pivot window; Excel has no buttons on it ribbons to create relationships.

Question

Quizplus · Accepted Answer

DA) Power Pivot works directly with data models. If there is no data model, Power Pivot has no data to display. D) Creating relationships between tables is a core functionality of Power Pivot, and while Excel does allow for creating relationships in the Data Model, Power Pivot provides a more advanced interface for managing these relationships.

Which of the Following Is True of Power Pivot