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

Question

​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

Quizplus · Accepted Answer

The PROPER function is specifically designed to convert the first letter of each word to uppercase and all other letters to lowercase, while also capitalizing any letter that does not follow another letter. CONCATENATE is a function used to join together text from multiple cells into one cell, Paste Values is a function used to replace a formula with the actual value, and Columns is not a function but rather a reference to a group of cells in a column.

​The _________ Function Converts the First Letter of Each Word

The _________ Function Converts the First Letter of Each Word