Question 1

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

Accepted Answer

The answer of Use the ________ function when you want...

Question 2

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

Accepted Answer

The answer of The ________ function could be used to...

Question 3

Jerry used a function to convert the following date 1/31/2012.The function he used returned the number 31.Jerry likely used the ________ function.

Accepted Answer

The answer of Jerry used a function to convert the...

Question 4

If the ________ function does not find the string supplied for the old_text argument,it will not return an error.

Accepted Answer

The answer of If the ________ function does not find...

Question 5

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

Accepted Answer

The answer of The ________ function is used to convert...

Question 6

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

Accepted Answer

The answer of The ________ function capitalizes the first letter...

Question 7

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

Accepted Answer

The answer of ________ is data about data such as...

Question 8

By definition,a(n)________ database is a collection of tables linked together by shared fields.

Accepted Answer

The answer of By definition,a(n)________ database is a collection of...

Question 9

A(n)________ indicates the beginning and end of a text data segment.

Accepted Answer

The answer of A(n)________ indicates the beginning and end of...

Question 10

Because Flash Fill involves less typing than traditional text functions,it can be easier to use on ________ devices.

Accepted Answer

The answer of Because Flash Fill involves less typing than...

Question 11

The ________ function returns the total number of characters in a string.

Accepted Answer

The answer of The ________ function returns the total number...

Question 12

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

Accepted Answer

The answer of ________ recognizes patterns in data as you...

Question 13

The ________ function removes the first 32 nonprinting character codes.

Accepted Answer

The answer of The ________ function removes the first 32...

Question 14

Match between columns
                        Premises: HTML
.csv
.txt
.accdb
XML

Accepted Answer

The Answer of Data stored in a comma-delimited format and is...

Question 15

Match between columns
                        Premises: XML
XML schema
XML element
HTML
Markup Language

Accepted Answer

The Answer of Defines the content of data so it is...

Question 16

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

Accepted Answer

The Answer of A simple container of text data and is...

Question 17

Match between columns
                        Premises: Foreign key
Microsoft Query
Primary key
Access database
Relational database

Accepted Answer

The Answer of Collection of tables linked by common fields is...

Question 18

Match between columns
                        Premises: LOWER
UPPER
CLEAN
TRIM
PROPER

Accepted Answer

The Answer of Capitalizes only the first letter in each is...

Question 19

Match between columns
                        Premises: LEN
RIGHT
LEFT
CONCATENATE
MID

Accepted Answer

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

Question 20

Match between columns
                        Premises: DATEVALUE
WEEKDAY
WORKDAY
DATE
DAY

Accepted Answer

The Answer of Returns the day of the month and is...

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

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

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

Jerry used a function to convert the following date 1/31/2012.The function he used returned the number 31.Jerry likely used the ________ function.

If the ________ function does not find the string supplied for the old_text argument,it will not return an error.

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

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

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

By definition,a(n)________ database is a collection of tables linked together by shared fields.

A(n)________ indicates the beginning and end of a text data segment.

Because Flash Fill involves less typing than traditional text functions,it can be easier to use on ________ devices.

The ________ function returns the total number of characters in a string.

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

The ________ function removes the first 32 nonprinting character codes.

Match the following terms with their description.

Match the following terms with their description.

Match the following terms with their description.

Match the following terms with their description.

Match the following terms with their description.

Match the following terms with their description.

Match the following terms with their description.