Which is true of an Excel Data Model?
A)It must consist of at least two related tables.
B)The data do not need to be stored in one or more Excel worksheets.
C)The data must first be imported into Excel from an RDBMS,either Access or SQL Server.
D)The data will always appear in two places: in one or more Excel worksheets and in the Power Pivot window.

Question

Quizplus · Accepted Answer

An Excel Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook. The data does not need to be stored in Excel worksheets; it can be imported from external sources like databases, text files, or other Excel workbooks.

Which Is True of an Excel Data Model