Exam 38: Imports, web Queries, and XML

Which of the following features will automatically complete lists?

When connections are being refreshed in a workbook the status bar displays the message running a ________ query.

Once XML data is imported,where can the data source be manipulated?

The LOWER function will capitalize the first letter of a text string.

Flash Fill can auto fill numerical lists.

The ________ function can join up to 255 text strings.

Which of the following file types uses tabs to separate data into columns?

Which of the following is not part of XML?

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

Which of the following is a feature in Excel that can often perform the same task as the PROPER function?

The UPPER function will capitalize every character of a text string.

The PROPER function will convert every character in a text string to lowercase.

XML files can be opened in Excel by using the ________.

Where can all connections in a workbook be viewed or edited?

When creating a Web query which option preserves all original formatting?

Access database tables cannot be imported into Excel.

<!-- Created June 29 1979 --> is an XML comment.

Which function will convert a text string to lowercase?