Solved

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions