Multiple Choice
Which of the following is true?
A) You can create a pivot table from the data in an Excel Data Model,but you must first ensure that Power Pivot is loaded.
B) You can create a pivot table from the data in an Excel Data Model even if Power Pivot is not loaded.
C) If your data are stored in an Excel Data Model,not in one or more worksheets,you can view the data regardless of whether Power Pivot is loaded.
D) Assuming that you want to build a pivot table and Power Pivot has not been loaded,your data should be stored in an Excel Data Model and in one or more worksheets.
Correct Answer:

Verified
Correct Answer:
Verified
Q18: Which of the following most accurately explains
Q19: Excel Data Model is a recent Microsoft
Q20: A hospital has a database for which
Q21: Microsoft refers to the role of add-ins
Q22: The initial step of correcting problems in
Q24: A Data Model is a _ that
Q25: In a many-to-many relationship the linking table
Q26: The DAX function RELATED is used for
Q27: A _ is a new column in
Q28: A foreign key resides in the "one"