Microsoft Excel Excel Text to Columns and Data Cleanup 2

Question 1

A column of numbers imported from a text file is stored as text and will not sum. Which technique converts the entire column to numbers at once?

Accepted Answer

Run Text to Columns and click Finish without changing options

Answer

Text to Columns re-parses each cell, converting numeric text to true numbers.

Question 2

Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?

Accepted Answer

Flash Fill

Answer

Flash Fill recognizes patterns and completes the column with Ctrl+E.

Question 3

Which function removes non-printable characters, such as those from web or database exports, from a text string?

Accepted Answer

CLEAN

Answer

CLEAN strips the first 32 non-printing ASCII characters.

Question 4

In Text to Columns, which choice is appropriate when a report has every field starting at the same character position on each line?

Accepted Answer

Fixed width

Answer

Fixed width splits at specified character positions rather than by a character.

Question 5

Which formula converts the text in A1 to have only the first letter of each word capitalized?

Accepted Answer

=PROPER(A1)

Answer

PROPER capitalizes the first letter of each word and lowercases the rest.

Excel Practice Test