Excel Text to Columns and Data Cleanup Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Excel Text to Columns and Data Cleanup flashcards as text
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?
Answer: Run Text to Columns and click Finish without changing options
Text to Columns re-parses each cell, converting numeric text to true numbers.
Which Excel feature automatically fills a column by detecting a pattern from examples you type, such as extracting first names?
Answer: Flash Fill
Flash Fill recognizes patterns and completes the column with Ctrl+E.
Which function removes non-printable characters, such as those from web or database exports, from a text string?
Answer: CLEAN
CLEAN strips the first 32 non-printing ASCII characters.
In Text to Columns, which choice is appropriate when a report has every field starting at the same character position on each line?
Answer: Fixed width
Fixed width splits at specified character positions rather than by a character.
Which formula converts the text in A1 to have only the first letter of each word capitalized?
Answer: =PROPER(A1)
PROPER capitalizes the first letter of each word and lowercases the rest.
You need to replace all hyphens in a phone number column with nothing so the digits are continuous. Which method accomplishes this in one action for the whole column?
Answer: Find and Replace with hyphen in Find what and nothing in Replace with
Find and Replace (Ctrl+H) removes a character across the selection instantly.