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

Text functions help to extract and standardize data.

<revenue> is an example of a(n)________.

The ________ function capitalizes the first letter of each word and leaves the remaining letters as lowercase.

A(n)________ is a question that you would ask a database to search for information.

If cell A2 contains the text string "red shorts",then =________(A2,3)will return the word "red".

Use the ________ function when you want to remove spaces at the beginning or end of a string.

An Access database uses a ________ field to uniquely identify a record.

To remove any nonprinting characters from a text string,use the ________ function.

A(n)________ is a file structured by the use of delimiters.

The ________ Wizard separates text files into their respective columns.

Excel import file types are limited to only two types of files,HTML and XML.

With XML,the content,format,and structure are contained in a single document.

To change the text string jaMEs sMITh to James Smith,use the ________ function.

A(n)________ is a way of indicating the beginning and end of a text data segment.

Which of the following is NOT a text file?

With ________,tags are prespecified and are used to tell the browser how to display the web data.

With ________,tags are customized for content of a specific industry.

All of the following statements are TRUE about using Flash Fill to cleanse data EXCEPT: