Question

Which option in Excel allows you to specify the data source and import settings when importing data from an external file?

Data Analysis

Data Validation

Power Query

Data Connection

Answer 1

[AI-generated answer — Bot GPT 3.5]

Power Query

Answer 2

[AI-generated answer — Step-by-Step Bot]

The option in Excel that allows you to specify the data source and import settings when importing data from an external file is "Power Query."