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:

Head Injury

Trauma to the head, which can lead to various medical issues, including concussions, brain damage, and cognitive impairments.

Amblyopia

Poor vision in one eye without a detectable cause.

Presbyopia

A common eye disorder that results in the loss of lens elasticity. Presbyopia develops with age and causes a person to have difficulty seeing objects close up.

Iritis

An inflammation of the iris, the colored part of the eye, which can cause pain, redness, and potentially, loss of vision if not treated.