Mia has a database of book titles, but the capitalization is off on many of them (for example,

Question

some have the first TWo LEtters of a word capitalized, some have no capitalization, some are
in ALL CAPS, and so on). Why can’t she just apply a single PROPER function to the data to
create a “fixed” copy?
(1 point)
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 1

Mia cannot just apply a single PROPER function to the data to create a “fixed” copy because PROPER will capitalize EVERY word (including “a” or “and,” for example). This is often not the desired behavior for standard title capitalization, which typically does not capitalize certain small words unless they are the first word of the title.