Exam 27: Excel: Imports, web Queries, and Xml

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

XML elements cannot be nested.

Which of the following tools is best suited for setting up a connection to a table on a Web page?

A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.

What possible issues can occur when using Web queries?

Web queries cannot import data from Web pages that are ________.

Which of the following applications can be used to create XML documents?

Text functions such as CONCATENATE and UPPER can be nested for more precise results.

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

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

Text files can be imported into Excel workbooks.

Which of the following describes importing data into Excel but do not maintaining a link to the original data source?

What is the difference between linking imported files and embedding imported files?

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

The ________ specifies the XML version and character encoding used.

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

Data tables from database programs such as Access and ________ Server can be imported into Excel.

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

The ________ function will replace an older text string with new text.