Compare upper, lower, proper and preserved text
Fill C2:G5 as twenty separate formulas. C uses UPPER, D LOWER and E PROPER on the same original row. F compares the original to E using EXACT. G uses CHOOSE and numeric B7: 1 selects C, 2 D, 3 E and 4 the untouched original B value. B2:B5 must be nonempty printable ASCII text up to 40 characters, including spaces, punctuation and numeric-looking spelling. Preserve all spaces and characters outside letter case. B7 is a numeric whole policy index 1..4. This bounded mechanical case comparison is not a name-correction service, title-style guide or multilingual capitalization certification.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Fill C2:G5 as twenty separate formulas. C uses UPPER, D LOWER and E PROPER on the same original row. F compares the original to E using EXACT. G uses CHOOSE and numeric B7: 1 selects C, 2 D, 3 E and 4 the untouched original B value. B2:B5 must be nonempty printable ASCII text up to 40 characters, including spaces, punctuation and numeric-looking spelling. Preserve all spaces and characters outside letter case. B7 is a numeric whole policy index 1..4. This bounded mechanical case comparison is not a name-correction service, title-style guide or multilingual capitalization certification.
No account. No upload. Just try it.