Which of the Following Is True of Power Pivot

question 46

Multiple Choice

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.

---

Definitions:

Entry

The act of inputting data into a system or the individual piece of data that is entered.

Database

A structured set of data held in a computer, especially one that is accessible in various ways.

Validation Text

Text displayed to a user when entered data does not conform to predefined rules, guiding them towards correct input.

Table Tools Fields Tab

A feature in database and spreadsheet software that provides specific tools and options for managing fields (columns) in tables.