Exam 37: Imports, web Queries, and XML: Hands-On-Exercise Videos

You can use ________ in conjunction with data in existing columns to separate the data into distinct columns.

When importing a text file into Excel,you must specify a delimiter.

The From Text,From Access,and From Web buttons are located on the ________ tab.

When creating a Web query,tables in the Web page are indicated by:

The text shown above represents information structured using ________ syntax.

When an XML document is edited,changes to the imported data are automatically updated in Excel.

Using the Convert Text to Columns Wizard is similar to using the Text Import Wizard.

An XML document can be edited in Notepad.

A Web query does not import the data,instead it creates a link to the Web page,which can be refreshed.

To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1,you would type ________.

In the expression,<High>270.65</High>,the <High> and </High> are referred to as ________.

Data imported from an Access table is formatted as a range of cells.

The ________ function is used to change NEW YORK to New York.