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

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

________ is a standalone desktop application that has Power View functionality outside of Excel

Which of the following are settings that control how imported data in cells connect to their source data?

What would be the return of the following function in C3? =LOWER(B3)

There are 27 Text string manipulation functions.

is an XML declaration.

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

The ________ function will change tabitha turner to Tabitha Turner.

What would be the return of the following function in C2? =CONCATENATE(A2," ",B2)

There are a total of ________ text manipulation functions in Excel.

Each data field or table added to a Power View canvas is called a(n)________.

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

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

Where can you open XML files in Excel?

Power Pivot can import XML data.

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

XML is ________.

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