Multiple Choice
The _________ function converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.
A) CONCATENATE
B) PROPER
C) Paste Values
D) Columns
Correct Answer:

Verified
Correct Answer:
Verified
Q17: This is a digital placeholder that displays
Q18: Text can contain: <br>A) Uppercase only <br>B) Lowercase only <br>C) Upper and lowercase <br>D) Numbers
Q19: Custom formats describe how Excel should display
Q20: The RIGHT function returns a specified number
Q21: The _ function joins,or concatenates,two or more
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
Q27: You can use the LEN and LEFT