What is the advantage of selecting the "Only Create Connection" option when importing data? Data is added to the data model so you can change the data as needed Data is added to the data model and cannot be changed in Excel Data is added to a table in a workbook It makes it much easier to clean the data by just changing it is Excel, allowing you to bypass making changes in the source data Confirm

When importing a Text file, why is it important to move through each step of the Text Import Wizard? a O The last step provides the option to select the column data format so you can select the format of Text for fields that have leading zeros it is the only way to allow the Text Import Wizard to refresh the import with new data The last step provides the option cente calculated columns The last step gives you the option to change the column headings (Tield names)