Question

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

Answer 1

External Data is the correct answer.

Step-by-step explanation:

In the following statement, if the user wants to transfer data from query to Excel then, they follow these steps.

• Firstly, they have to click on the Tools.
• Then, they click on the options.
• Then, they have to click on the Query then, click on the external data on the ribbon.
• Finally, they click on the Excel button.