When you want to load data such as an Access table into the Data Model, which option do you select in the Import Data dialog box?
A) Add this data to the Data Model
B) Existing worksheet
C) New worksheet
D) Queries pane

Question

Quizplus · Accepted Answer

Selecting "Add this data to the Data Model" option will add the data directly to the Excel Data Model, allowing for advanced filtering and analysis using Power Pivot or Power Query. The other options do not add the data to the Data Model.

When You Want to Load Data Such as an Access