Question

Mia has a database of book titles, but the capitalization is off on many of them (for example, 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)
Responses

PROPER will capitalize EVERY word (including “a” or “and,” for example).

PROPER will capitalize EVERY word (including “a” or “and,” for example).

PROPER will only capitalize the first word of each cell.

PROPER will only capitalize the first word of each cell.

PROPER will capitalize EVERY letter.

PROPER will capitalize EVERY letter.

PROPER won’t work on the ALL CAPS titles.

PROPER won’t work on the ALL CAPS titles.

Answer 1

PROPER will capitalize EVERY word (including “a” or “and,” for example).