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

Embedded data has no the link to its original source.

Which is not true about building PivotTables in Power Pivot?

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

________ properties are settings that control how imported data in cells connect to their source data.

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

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.

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

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

What is a relationship in Power Pivot?

Importing XML data into Excel enables you to maintain a link and ________ data.

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

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

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

Which of the following is a required in XML?

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

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

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

Flash Fill only fills formulas.

XML elements cannot be nested.