Analyzing and Visualizing Data with Microsoft Excel — Question 64

You have 20 workbook queries that load 20 CSV files to a local computer.
You plan to send the workbook and the 20 CSV files to several users. The users will store the files in various locations.
You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible.
What should you do from Query Editor?

Answer options

• A. Append all the queries. Edit the source of the first query
• B. Merge all the queries. Edit the source of the first query
• C. For each query, create a new query that uses a reference. Modify the source of each new query
• D. Create a parameter. Modify the source of each query to use the parameter

Correct answer: D

Explanation

Creating a parameter allows users to easily change the file path for all queries at once, ensuring a quick update process. The other options either require more effort to update each individual query or do not provide a straightforward way to manage the file paths.