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.

---

Definitions:

Mopane Worm

A caterpillar in Southern Africa that is harvested for food, known scientifically as Gonimbrasia belina.

Generalization

The process in a learning context where a response is elicited by stimuli similar to the original stimulus.

Facilitate

To make an action or process easier by providing assistance or reducing obstacles.

Cognitive Psychology

Cognitive psychology is a branch of psychology that studies mental processes such as perception, thinking, memory, and decision-making.