NEW
Font size
WorksheetsData Cleaning & Lookup Functions Quiz (week 2)
Total questions: 15
Worksheet time: 8mins
Which function removes leading and trailing spaces?
CLEAN
TRIM
REPLACE
SUBSTITUTE
Which function capitalizes the first letter of each word?
UPPER
PROPER
TITLE
FORMAT
Which function converts all text to lowercase?
LOWER
DOWN
SMALL
LCASE
Which tool removes duplicates?
Data → Sort
Data → Remove Duplicates
Insert → Table
Review → Delete
The shortcut for Flash Fill is:
Ctrl + D
Ctrl + E
Ctrl + L
Ctrl + Shift + E
Text to Columns is used to:
Join two columns
Split data into columns
Remove blanks
Format numbers
VLOOKUP searches for a value in:
The first row
The first column
Any row
Any cell
HLOOKUP searches for a value in:
The first row
The first column
The last row
The last column
XLOOKUP can replace which functions?
VLOOKUP only
HLOOKUP only
Both VLOOKUP & HLOOKUP
None
Which error means a lookup value is missing?
N/A
REF!
VALUE!
NAME?
INDEX function returns:
Row number
Value from a row/column
Column number
Error
MATCH function returns:
The value itself
The position of the value
The average
None
VLOOKUP requires the lookup value to be in:
Any column
The last column
The first column
The middle column
Which function replaces text within a string?
SUBSTITUTE
REPLACE
CHANGE
EDIT
Which function removes all non-printable characters?
CLEAN
TRIM
DELETE
