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

Power Query is a tool to help visual big data.

You cannot separate data in a single column into multiple columns.

A(n)________ contains a slash (/)and the name of the element enclosed in <>.

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

An alternative to the CONCATENATE function is to use ________ to join strings.

What do you call characters that separate data?

If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name columns,what would happen if you separated the names at the space between first name and last name without making any other changes to the table?

________ is an Excel add-in that enables you to build a visual dashboard with the functionality of a PivotTable.

Power Pivot is installed in all version of Excel.

The ________ function will replace one string with another.

A(n)________ links two tables together for a Power Pivot PivotTable.

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

________ is an industry standard for structuring data across applications,operating systems and hardware.

________ is the process of inserting external data created or stored in another format into the current application.

________are data fields and tables added to the Power View canvas.

Power Query can do 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.

The TRIM function removes leading and trailing spaces in a text string but maintains spaces between words.

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