Question 1

The ________ specifies the XML version and character encoding used.

Accepted Answer

The answer of The ________ specifies the XML version and...

Question 2

Match between columns
                        Premises: Delimiters
Embed
Text file
Tab-delimited
Importing

Accepted Answer

The Answer of The process of inserting external data created is...

Question 3

Match between columns
                        Premises: Delimiter
Text file
CSV
Tab-delimited
Newline character

Accepted Answer

The Answer of Special characters that separate data and Comma is...

Question 4

Match between columns
                        Premises: HTML formatting
Web Query Options dialog box
Login required
Web query
Rich text formatting

Accepted Answer

The Answer of This is not supported by Web queries is...

Question 5

Text can be converted into separated columns using the ________ Wizard.

Accepted Answer

The answer of Text can be converted into separated columns...

Question 6

Match between columns
                        Premises: Refresh all
Workbook Connections dialog box
Running background query
Connection
Data range properties

Accepted Answer

The Answer of Contains tools for setting connection properties and is...

Question 7

________ is a feature in Excel that can often perform the same tasks as the PROPER and CONCATENATE functions.

Accepted Answer

The answer of ________ is a feature in Excel that...

Question 8

XML files can be opened in Excel by using the ________.

Accepted Answer

The answer of XML files can be opened in Excel...

Question 9

Match between columns
                        Premises: LOWER
UPPER
PROPER
SUBSTITUTE
CONCATENATE

Accepted Answer

The Answer of Joins up to 255 text strings and is...

Question 10

When using XML,the ________ contains the name of an element preceded by a slash.

Accepted Answer

The answer of When using XML,the ________ contains the name...

Question 11

A(n)________ is a special character that designates the end of a line and separates data for the next line or row.

Accepted Answer

The answer of A(n)________ is a special character that designates...

Question 12

Match between columns
                        Premises: LEFT
SUBSTITUTE
RIGHT
MID
TRIM

Accepted Answer

The Answer of Returns the specified number of characters from is...

Question 13

Match between columns
                        Premises: XML declaration
XML
Element
End tag
Start tag

Accepted Answer

The Answer of eXtensible Markup Language and Contains the name is...

Question 14

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

Accepted Answer

The answer of A(n)________ is a data file that contains...

Question 15

Match between columns
                        Premises: XML
Comment
End tag
XML declaration
Start tag

Accepted Answer

The Answer of  and eXtensible Markup is...

Question 16

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

Accepted Answer

The answer of Data tables from database programs such as...

Question 17

A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.

Accepted Answer

The answer of A(n)________ is a user-defined marker that identifies...

Question 18

Match between columns
                        Premises: TRIM
CONCATENATE
SUBSTITUTE
&
RIGHT

Accepted Answer

The Answer of Replaces old text in a text string is...

Question 19

Match between columns
                        Premises: Flash Fill
Delimiters
Convert Text to Columns Wizard
CSV
XML

Accepted Answer

The Answer of Comma separated values and eXtensible Markup Language is...

Question 20

XML stands for ________ Markup Language.

Accepted Answer

The answer of XML stands for ________ Markup Language....

Quiz 38: Imports, web Queries, and XML

The ________ specifies the XML version and character encoding used.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

Text can be converted into separated columns using the ________ Wizard.

Match the following terms with the corresponding description:

________ is a feature in Excel that can often perform the same tasks as the PROPER and CONCATENATE functions.

XML files can be opened in Excel by using the ________.

Match the following terms with the corresponding description:

When using XML,the ________ contains the name of an element preceded by a slash.

A(n)________ is a special character that designates the end of a line and separates data for the next line or row.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

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

Match the following terms with the corresponding description:

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

A(n)________ is a user-defined marker that identifies the beginning or ending of a piece of data in an XML document.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

XML stands for ________ Markup Language.