Page 11 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You learned in the practice that when you import data using Query, the Query Wizard always opens.

True.

False.

You learned in the practice how to save a query. You would:

On the File menu, click Save.

Click the Save Query button in the Choose Data Source Dialog box.

Click the Save Query button in the Query Wizard.

When you import data using Query, you must filter and sort it.

True.

False.

As you learned in the practice, you find a saved query on the _____.

Queries tab.

Saved Queries tab.

Databases tab.

Page 11 of 12PREVNEXT