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

________ is a business intelligence tool that provides the user with the ability to import, shape, cleanse, and query data.

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

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

Text can be converted to separate columns using the Convert ________ Wizard.

Which of the following is a required in XML?

Power Pivot is installed in all version of Excel.

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

The ________ function will change sam smith into SAM SMITH.

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

Power View can perform aggregate calculations, create charts and format data.

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

What do you call characters that separate data?

Embedded data has no the link to its original source.

If you do not want to create a link to an Access database table ________.

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

A company changes name from Wally's Widgets to Wally's Wonders.Which function would change all Wally's Widgets to Wally's Wonders?

What does XML stand for?

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

Power BI is a ________.