FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) use the Embed Access table command
B) copy each line of data from Access and paste into an Excel worksheet
C) open the table in Access and select data and field names and then copy and paste it into an Excel worksheet
D) Excel had no capacity to do this.It must be done in Access.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) STEWART
B) Stewart
C) stewart
D) Aaron Stewart

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Power Pivot can import XML data.

Match each of the following concepts to its best description:

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

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

Match each of the following functions to its best description:

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

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

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

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

XML is ________.

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

The ________ function will change tabitha turner to Tabitha Turner.

Where can you open XML files in Excel?

is an XML declaration.

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

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

There are 27 Text string manipulation functions.

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