Display is mistaken for stored text
A line break is an actual character. A space is nonempty text. A case-insensitive comparison can conceal a capitalization difference.
Compare upper, lower, proper and preserved text
Read-only
Step-by-step guide · read-only ·
Loading your interactive spreadsheet…
Preparing the worksheet and formulas…
Data & tools
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.
Follow the highlighted cells. Switch to Your turn to edit. Answer cells: C2, C3, C4, C5, D2, D3, D4, D5, E2, E3, E4, E5, F2, F3, F4, F5, G2, G3, G4, G5. Browser calculations may differ from your Excel version.
Inspect current stored results and formulas
| Cell | Current value | Applied formula |
|---|---|---|
| C2 | — | No formula |
| C3 | — | No formula |
| C4 | — | No formula |
| C5 | — | No formula |
| D2 | — | No formula |
| D3 | — | No formula |
| D4 | — | No formula |
| D5 | — | No formula |
| E2 | — | No formula |
| E3 | — | No formula |
| E4 | — | No formula |
| E5 | — | No formula |
| F2 | — | No formula |
| F3 | — | No formula |
| F4 | — | No formula |
| F5 | — | No formula |
| G2 | — | No formula |
| G3 | — | No formula |
| G4 | — | No formula |
| G5 | — | No formula |
Change an actual source value
B2:B5 accept nonempty printable ASCII text up to 40 characters. Keep spaces and reviewed spelling. B7 selects 1 Upper, 2 Lower, 3 mechanical PROPER or 4 original text. This comparison does not infer correct personal names or international casing.
This draft matches the current cell.
Selection & formula search
Practice stays on this device. No worksheet data is uploaded.
Notes & examples
About this lesson
Compare three capitalization methods beside the untouched source, reveal case-sensitive changes and choose a policy explicitly.
THE QUICK ANSWER01
Compare three capitalization methods beside the untouched source, reveal case-sensitive changes and choose a policy explicitly.
C2
=UPPER(B2)C3
=UPPER(B3)C4
=UPPER(B4)C5
=UPPER(B5)D2
=LOWER(B2)D3
=LOWER(B3)D4
=LOWER(B4)D5
=LOWER(B5)E2
=PROPER(B2)E3
=PROPER(B3)E4
=PROPER(B4)E5
=PROPER(B5)F2
=EXACT(B2,E2)F3
=EXACT(B3,E3)F4
=EXACT(B4,E4)F5
=EXACT(B5,E5)G2
=CHOOSE($B$7,C2,D2,E2,B2)G3
=CHOOSE($B$7,C3,D3,E3,B3)G4
=CHOOSE($B$7,C4,D4,E4,B4)G5
=CHOOSE($B$7,C5,D5,E5,B5)For the example data
C2 NASA DISPATCHD2 nasa dispatchE2 Nasa DispatchF2 falseG2 Nasa DispatchC3 O'NEILLD3 o'neillE3 O'NeillF3 falseG3 O'NeillC4 76BUDGETD4 76budgetE4 76BudgetF4 falseG4 76BudgetC5 MCDONALDD5 mcdonaldE5 McdonaldF5 falseG5 Mcdonald
Enter each formula in its labeled answer cell. These report formulas perform different jobs; do not fill the first formula down.
How it works
Keep the original source intact
Compare the derived outputs beside the original text. Capitalization, spaces and actual missing cells are different decisions; a readable display alone does not prove that the stored text is correct.
Use an explicit output policy
Every output follows a declared case or line-separator rule. Change the actual source or control cell and inspect the recalculated report before exporting your current workbook.
Check the complete current report
Independent source-only checks cover eight retained populations and three changed-source probes. Both the formula copy and values-only copy retain the applied source and current results; teaching demonstrations alone do not award credit.
Read the full step-by-step walkthrough
- Keep reviewed source spelling beside every comparison
B2:B5 are literal printable ASCII text, including numeric-looking text and spaces. Do not trim or rewrite the original. These mechanical English examples do not prescribe correct personal names or international casing.
- Compare all-uppercase and all-lowercase policies
C and D change only letters. Spaces, punctuation and digits remain. Use these transformations only when the destination calls for that explicit policy.
- Inspect what PROPER actually capitalizes
E uppercases letters at the start or after nonletters and lowercases other letters. Digits, underscores and apostrophes create boundaries. Acronyms and reviewed mixed spelling can lose meaning.
- Use a case-sensitive change check
F uses EXACT to compare the original with mechanical PROPER. A FALSE result means a spelling change, not proof that either form is correct. An ordinary equals comparison can ignore case.
- Choose an output policy in the actual control cell
B7 selects 1 uppercase, 2 lowercase, 3 mechanical PROPER or 4 original reviewed spelling. G reads the corresponding same-row value. Change the live control instead of editing a fixed answer.
- Test a changed spelling and retain original identity
Compare an acronym, an apostrophe and a reviewed mixed-case name. Recheck the complete source-dependent report and export the current formulas or frozen values.
Things to watch
A transformation is treated as a correction
A consistent case policy is useful only when it fits the destination. Preserve reviewed identity spellings and inspect punctuation or acronym changes.
A fixed result replaces a source-dependent formula
Current data, all retained sources and independent changed controls must produce the complete report.
About this example
Original bounded browser practice. Native regional rendering, calculation and edit/save are not certified.
Content version 1. Practice checks compare calculated results across different datasets; they do not certify every possible formula.