Exam 38: Imports, web Queries, and XML

The SUBSTITUTE function will replace the word doctor with Dr.in a text string.

XML stands for ________ Markup Language.

You ________ data when you import data from an external source without maintaining a link to the original data.

Tab-delimited files use tabs to separate data into columns.

Which function is best suited to return the specified number of characters from the middle of a text string?

The maximum number of text strings supported by the CONCATENATE function is 255.

________ are settings that control how imported data in cells connect to their source data.

Which of the following are settings that control how imported data in cells connect to their source data?

Text files can be imported into Excel workbooks.

When connections are being refreshed,Excel displays the message "Running background query" in the status bar.

Which function is best suited to remove extras spaces from the beginning of a text string?

When using XML,the ________ contains the name of an element preceded by a slash.

Where can XML files be opened in Excel?

Microsoft Access data tables and ________ can be imported into Excel.

What message is displayed in the status bar when a connection is being updated?

________ is the process of inserting external data created or stored in another format into the current application.

Which of the following is a not an Excel file type?

Web queries cannot accurately import data from Web sites that are password protected.

What are the main components of XML?

What does XML stand for?