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:

Computer Type

Refers to the category of computer based on its size, functionality, and purpose, such as desktop, laptop, or tablet.

Printed Matter

Materials that are printed and distributed, such as books, magazines, flyers, and posters.

Input Device

Hardware used to enter data or instructions into a computer or other electronic system.

Pointing Device

A hardware input device used to allow a user to input spatial data into a computer, such as a mouse, trackpad, or stylus.