Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Selects data from the Internet to add to an Excel worksheet.
Switched rows and salumns for imported data.
Save as type to create a template workbook.
A text file with data fields of equal length and spaces between the fields.
Method to import an Access table into an Excel worksheet when both applications are open.
Imported data that maintains a refreshable link to its external source.
A popular format for data exchange.
A special-purpose workbook used as a pattern to create similar workbooks.
Another term for sapying formulas.
Sample data used in place of actual data to verify formulas in a template.
Responses:
XML
fixed width file
drag and drop
template
replication
Excel Template
external data
Web query
dummy data
transposed
Correct Answer:
Premises:
Responses:
Selects data from the Internet to add to an Excel worksheet.
Switched rows and salumns for imported data.
Save as type to create a template workbook.
A text file with data fields of equal length and spaces between the fields.
Method to import an Access table into an Excel worksheet when both applications are open.
Imported data that maintains a refreshable link to its external source.
A popular format for data exchange.
A special-purpose workbook used as a pattern to create similar workbooks.
Another term for sapying formulas.
Sample data used in place of actual data to verify formulas in a template.
Premises:
Selects data from the Internet to add to an Excel worksheet.
Switched rows and salumns for imported data.
Save as type to create a template workbook.
A text file with data fields of equal length and spaces between the fields.
Method to import an Access table into an Excel worksheet when both applications are open.
Imported data that maintains a refreshable link to its external source.
A popular format for data exchange.
A special-purpose workbook used as a pattern to create similar workbooks.
Another term for sapying formulas.
Sample data used in place of actual data to verify formulas in a template.
Responses:
Related Questions
Q62: Deployments are most helpful when you need
Q71: The only difference between developing a workbook
Q72: The Find and Replace dialog box has
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents