Crystal has a database of book titles, but the capitalization is off on many of them (e.g., some have the first TWo LEtters of a word capitalized, some have no capitalization, some are in all caps, etc.). Why can't she just apply a single PROPER function to the data to create a "fixed" copy? PROPER will capitalize EVERY word (including "a" or "and," for example). PROPER will only capitalize the first word of each cell. PROPER will capitalize EVERY letter. PROPER won't work on the ALL CAPS titles.

Answer rating: 100% (QA)

The correct answer is PROPER will capitalize EVERY word includin... View the full answer