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

1. The Excel Data Model is a feature that allows you to integrate data from multiple sources, not limited to data stored directly in Excel worksheets. 2. Although you can include two or more related tables in the data model, it is not mandatory that the model must consist of at least two related tables. You can have even a single table in the data model. 3. The data can come from a variety of sources, not just directly from a relational database management system (RDBMS) like Access or SQL Server. It can also come from text files, other databases, and more. 4. The data in an Excel Data Model does not necessarily appear in an Excel worksheet. It exists within the data model itself, which can be used by tools like Power Pivot without visible duplication on the worksheet. Thus, the correct statement is: - The data do not need to be stored in one or more Excel worksheets.