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

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

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

The ________ function will convert all characters in a text string to lowercase.

Which of the following sources cannot be imported into Excel?

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

A(n)________ is a special character that designates the end of a line and separates data for the next line or row.

A(n)________ file uses tabs to separate data into columns that can be imported into Excel.

Flash Fill is located on the Ribbon.

Which of the following is a file type that cannot 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 file types uses tabs to separate data into columns?

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

Which of the following is not a limitation when working with Web queries?

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

Flash Fill can auto fill numerical lists.

A ________ can import data from data tables on a Web page.

When importing an Access database table,Excel: