Data Cleaning & Lookup Functions Quiz (week 2)

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?