2.3 Test your knowledge on cleaning data in spreadsheets

What is the relationship between a text string and a substring?

A. A text string is a group of characters within a cell. A substring is a smaller subset of that text string

B. A text string is a row of data within a table. A substring is one cell within that row.

C. A text string is the list of attributes at the top of columns within a table. A substring is a single attribute within that list.

D. A text string is a column of data within a table. A substring is one cell within that column

A. A text string is a group of characters within a cell. A substring is a smaller subset of that text string

2. A data analyst uses the COUNT IF function to count the number of tins a value less than 50 occurs between spreadsheet cells D2 through F100. What is the correct syntax?

A. =COUNTIF (D2:F100,>50)

B. =COUNTIF (D2:F100,<50)

C. =COUNTIF (D2:F100,">50”)

D. =COINTTF (D2:F100,“<50”)

D. =COINTTF (D2:F100,“<50”)

3. Fill in the blank: To remove leading, trailing, and repeated spaces in data, analysts use the function.

A. LEFT

B. MID

C. RIGHT

D. TRIM

D. TRIM

Which spreadsheet tool searches for matches to a specified value in one column, returning a corresponding piece of information from another location?

A. SPLIT

B. LEN

C. VLOOKUP

D. CONCATENATE

C. VLOOKUP