Exam 10: Imports, Xml, and Power Add-Ins

Flash Fill only fills formulas.

You can import text files into Excel workbooks.

XML elements cannot be nested.

The ________ function will change tabitha turner to Tabitha Turner.

Power Pivot can import XML data.

Power Pivot delivers everything in PivotTables plus all of the following except ________.

To view XML data in Excel in a columnar format, choose the as a(n)________ option in the Open XML dialog box.

=CONCATENATE(PROPER("adam")," ",PROPER("smith"))would return Adam Smith.

You cannot maintain a connection with an XML source file.

Tab-delimited files use tabs to separate data into new rows.

If you import web data directly into Power Pivot and discover there are a lot of errors and inconsistencies, use ________ to clean it up.

Power View is installed by default.

A CSV file has no newline characters.

The true benefit of Power Query is in its ability to manipulate the data before importing it into Excel.

Which of the following functions is not a text string manipulation tool?

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

A tab character separates data into columns in a CSV.

Describing XML as ________ means that it can be expanded as necessary to fit the needs of the data.