Exam 38: Imports, web Queries, and XML

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

The ________ specifies the XML version and character encoding used.

Which of the following is a file type that cannot be imported into Excel?

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

What possible issues can occur when using Web queries?

Web queries cannot import data from Web pages that are ________.

The CONCATENATE function could combine the words Microsoft and Excel into one text string.

XML elements cannot be nested.

Web queries refresh data automatically.

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

Which of the following tools is best suited for setting up a connection to a table on a Web page?

The ________ function removes extra spaces from the beginning and end of a text string.

Which function is best suited to capitalize the first letter of each word in a text string?

What is the following syntax <? Xml version="1.0" encoding="UTF-8"? >

Which of the following options will refresh connections within an Excel workbook?

Which function will convert a text string to all capitals?

You embed the data within a worksheet when you import data and maintain the link to its original source.

What governing body created XML?