Suppose You Try to Create a Pivot Table from Multiple

question 13

Multiple Choice

Suppose you try to create a pivot table from multiple tables stored in a Data Model and,when you check a particular field to be placed in the pivot table,you get a warning about a missing relationship.Which of the following does this not imply?

• A)You are trying to use fields from unrelatable tables,so no matter what you do,your pivot table results will be wrong.
• B)You can open the Power Pivot window,create the missing relationships,and try building the pivot table again.
• C)You can click the Auto-Detect button in the PivotTable Fields pane,and the chances are that Excel will correctly create the missing relationship.
• D)You can click the CREATE button in the PivotTable Fields pane,which allows you to manually create the missing relationship.