Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

Question
What is the advantage of selecting the “Only Create Connection" option when importing data?
### Understanding the "Only Create Connection" Option in Data Import

When importing data, one of the options available is "Only Create Connection." Selecting this can have specific advantages:

1. **Data is added to the data model so you can change the data as needed**
   - This option means the data is linked and updates can be managed as required.

2. **Data is added to the data model and cannot be changed in Excel**
   - This suggests the data is linked, but is not modifiable directly within Excel.

3. **Data is added to a table in a workbook**
   - This indicates the data is directly placed into a table within the spreadsheet.

4. **It makes it much easier to clean the data by just changing it in Excel, allowing you to bypass making changes in the source data**
   - This option highlights the ease of modifying data directly in Excel, without altering the source.

This feature is beneficial for managing how data interacts with Excel, either maintaining a live connection or embedding data directly, allowing for various levels of data manipulation and management.
expand button
Transcribed Image Text:### Understanding the "Only Create Connection" Option in Data Import When importing data, one of the options available is "Only Create Connection." Selecting this can have specific advantages: 1. **Data is added to the data model so you can change the data as needed** - This option means the data is linked and updates can be managed as required. 2. **Data is added to the data model and cannot be changed in Excel** - This suggests the data is linked, but is not modifiable directly within Excel. 3. **Data is added to a table in a workbook** - This indicates the data is directly placed into a table within the spreadsheet. 4. **It makes it much easier to clean the data by just changing it in Excel, allowing you to bypass making changes in the source data** - This option highlights the ease of modifying data directly in Excel, without altering the source. This feature is beneficial for managing how data interacts with Excel, either maintaining a live connection or embedding data directly, allowing for various levels of data manipulation and management.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education