Multiple Choice
Which of the following most accurately explains Excel's Data Model and Power Pivot (in Excel 2016 or later versions) ?
A) Excel's Data Model and Power Pivot are synonyms for the same technology: for creating pivot tables based on large databases.
B) The Data Model and Power Pivot are both Excel add-ins.You must check each of them in the add-ins list before you can use them.
C) The Data Model is used to store and relate tables in Excel,and Power Pivot provides a user interface for using the Data Model to create pivot tables.
D) A Data Model requires VLOOKUP functions to relate table data,and then Power Pivot can be used to create pivot tables from the related data.
Correct Answer:

Verified
Correct Answer:
Verified
Q13: Suppose you try to create a pivot
Q14: The flexibility of the measures created by
Q15: The pivot table functionality that has been
Q16: In terms of importing data from a
Q17: When there is a many-to-many relationship,it is
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
Q23: Which of the following is true?<br>A)You can