Multiple Choice
You can use the LEN and LEFT functions nested in a(n) ____ function to convert all of the zip codes to the shorter form.
A) IF
B) MID
C) Text
D) PROPER
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q22: The _ function converts the first letter
Q23: Text contains one or more characters and
Q24: The Search text function returns the number
Q25: Custom formats use _ codes ,which are
Q26: Excel makes special note of _ zeros,which
Q28: This symbol displays Months as 1 through
Q29: The UPPER function converts all letters of
Q30: The four most commonly used formats are
Q31: When you have dates,times,or both in a
Q32: When you save an Excel 2007,2010,2013,or 2016