Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
What is the advantage of selecting the “Only Create Connection" option when importing data?
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
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