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

This feature is a productivity tool which interprets patterns and completes data entry based on the pattern you establish.

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

The ________ is the area that contains the dashboard data visualizations in Power View.

Power BI is an online application suite deigned to help manage, supplement, visualize and analyze data.

On which tab is the Text to Columns Wizard?

Right-clicking in an XML area and selecting XML will start the import or refresh process.

Data stored in tables on websites often produce a lot of errors because of additional web design languages formating the table on the web page.Which tool would be best suited to clean data downloaded from a website.

A(n)________ is a data file that contains characters, such as letters, numbers, and symbols, including punctuation and spaces.

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?

Which message displays in the status bar when a connection is being updated?

What would be the return of the following function in C4? =PROPER(A4)

What application could be used to create an XML document in its native file format?

Use the ________ function to combine text from multiple columns.

A(n)________ is a user defined marker that identifies the beginning and ending of a piece of data.

Power Pivot is an available add-in for ________ users.

The SUBSTITUTE function has an optional argument that enables you to replace the third occurrence of a string.

Power Query is a tool to help visual big data.

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