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.

---

Definitions:

Negative Reinforcement

A behavioral concept where the removal of an unfavorable event or outcome after the display of a behavior increases the likelihood of that behavior being repeated in the future.

Desirable Behaviour

Actions or reactions that are preferred in a particular context, often aligning with certain norms or goals.

Contingent Reinforcement

A behavioral strategy where the provision of rewards or punishments is directly linked to the occurrence or non-occurrence of a specific behavior.

Rewards

Benefits or recognition provided to individuals or groups for their performance and achievements.