Which of the Following Most Accurately Explains Excel's Data Model

question 18

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.