Exam 9: Organize, import, export, and Cleanse Data Sets

Formatting for an XML document is saved with the ________ file extension.

________ is data about data such as source information,key words,and captions.

To save a web query in Excel,use the ________ on the Data tab.

________ is a special tool that makes it easy to connect Excel to an Access database.

The DATEVALUE function can be used to calculate the number of available work days between two given dates.

A web query will always be able to access information even when the URL changes.

To change the text string James Smith to JAMES SMITH,use the ________ function.

The ________ function is used to convert a date represented by text to a serial number.

The following is an example of the ________ data type. PNum PName Shipped Quantity 59313 XL_Golf_Shirts 3_15_13 35 72316 Mens_Shoe 2_5_13 10 47423 Head_covers 3_6_/13 20

________ recognizes patterns in data as you type and automatically fills in values for text and numeric data.

Most people prefer to use Access over Excel to chart and analyze data.

The ________ function could be used to make sandbox out of the two words sand and box.

A delimiter is just a way of indicating the beginning and end of a text data segment.

The ________ function removes the first 32 nonprinting character codes.

Data cleansing is the process of validating that the data is correct and accurate.

An Excel web query creates a(n)________ to the original web page so that you will have the most up-to-date data .

The MONTH function returns the name of the month.For example 11/11/2013 would return November.

Excel cannot connect to an Access database; rather,data must be copied and pasted into a spreadsheet.

Some companies use Internet queries on their websites to make their data available to users.