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

The ________ function can join up to 255 text strings.

Which of the following is the best option for transferring data between incompatible systems?

What is the maximum number of strings that can be manipulated with the CONCATENATE function?

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

________ is a feature in Excel that can often perform the same tasks as the PROPER and CONCATENATE functions.

CSV files can be imported into an Excel workbook.

You embed the data within a worksheet when you import data and maintain the link to its original source.

Web queries refresh data automatically.

Where can XML files be opened in Excel?

Indentation indicates the hierarchy structure in XML.

What are the main components of XML?

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

The ________ function will capitalize all characters in a text string.

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

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

XML stands for eXtensible Markup Language.

Flash Fill can often perform the same tasks as the PROPER function.

Which feature is best suited to split imported text into multiple columns?

The CONCATENATE function could combine the words Microsoft and Excel into one text string.