Explain the difference between opening a text file directly in Excel and using Get & Transform to import text file data.

What will be an ideal response?


Opening a text file directly imports the data directly into Excel using the Text Import Wizard without any connection to the original text file. Using Get & Transform creates a connection to the text file so that changes made to the text file will update in the Excel workbook as well.

Computer Science & Information Technology

You might also like to view...

?Your iPhone app project team has identified that the marketing campaign part of the project can be delayed a bit, without delaying the entire project. So, technically, the marketing campaign is on the critical path of the project.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

A. logical B. constant C. consistent D. calculated

Computer Science & Information Technology

A button can be formatted using ________

A) Form Operations B) a Command button C) Quick Styles D) a Pop Up form

Computer Science & Information Technology

Match the following ways of proving intent with their definitions

I. Repetitive acts A. Destroying documents prior to an investigation II. Concealment B. Showing perp had a chance to commit crime III. Motive C. Is a strong circumstantial element IV. Opportunity D. Finding multiple events of the same error

Computer Science & Information Technology