Preserve the survey's meaning before accepting or overriding an invalid entry
Use a cell–rule–alert-style–codebook–evidence–dataset chain. Identify the exact cell and field, inspect the validation condition and message, compare it with the survey question and permitted codes, correct a transcription error or document a legitimate exception through the authorised route, then circle invalid data and audit copied values before calculating results.
Why this English matters now
Reading an Excel data-validation warning before entering survey results is practical English for students searching why Excel rejects a value, what Stop, Warning and Information mean, or whether Yes should be chosen for an invalid survey entry.
Microsoft explains that a Stop alert prevents invalid entry, while Warning and Information alerts can let a user continue. Microsoft also notes that copied or filled data may bypass validation messages and that existing invalid data is not automatically announced, although Excel can circle it.
Strong readers compare the warning with the cell rule, question wording and survey codebook; decide whether the value is an error, a legitimate exception or a rule-design problem; preserve raw evidence; and verify the full dataset before analysis. English matters because invalid, allowed, warning, retry, cancel, accept and circle describe different decisions.
Checked against the linked first-party sources on 30 October 2026. Interfaces, managed-device rules and school procedures can change, so reopen the current source before a live assessment, disclosure or account decision.
The practical reading method
Use a cell–rule–alert-style–codebook–evidence–dataset chain. Identify the exact cell and field, inspect the validation condition and message, compare it with the survey question and permitted codes, correct a transcription error or document a legitimate exception through the authorised route, then circle invalid data and audit copied values before calculating results.
- A validation warning reports a rule mismatch; it does not automatically prove that the respondent's answer or the entered value is wrong.
- Stop, Warning and Information alerts have different enforcement strength, so the available buttons are part of the meaning.
- Data validation protects typed entry imperfectly: copied, filled or inherited values can require a separate dataset audit.
- The survey codebook owns the intended meaning of categories, missing values and exceptional cases; a spreadsheet prompt should implement that meaning, not silently rewrite it.
Official factual floor
- Microsoft Support: More on data validation
- Microsoft Support: Apply data validation to cells
- MOE English Language Syllabus 2020
- IMDA Digital Skills for Life
- Microsoft distinguishes Stop, Warning and Information error alerts: Stop blocks invalid entry; Warning can accept it with Yes; Information can accept it with OK.
- Microsoft says existing invalid data is not automatically announced when validation is applied later and documents Circle Invalid Data for identifying it.
- Microsoft warns that copied or filled data can bypass validation messages and advises contacting the workbook owner when a validation alert is unclear.
Did You Know?
A validation rule can be perfectly enforced and still be conceptually wrong. If a survey permits Not applicable but the allowed list contains only Yes and No, Excel may correctly reject a legitimate response. The reader must test both the data and the rule against the codebook.
Full chapter index
- 1. Identify the survey field before interpreting the alert
- 2. Read the input message before typing
- 3. Distinguish Stop, Warning and Information
- 4. Read the validation condition
- 5. Compare the rule with the survey codebook
- 6. Separate transcription error from legitimate exception
- 7. Preserve the raw response before recoding
- 8. Handle list entries and spaces carefully
- 9. Understand copied data bypass risk
- 10. Circle inherited invalid data
- 11. Check formulas and referenced cells
- 12. Verify dataset-level meaning
- 13. Write a validation decision receipt
The mechanism
The column heading, question number, respondent row and data type establish what the cell is meant to represent.
A validation warning reports a rule mismatch; it does not automatically prove that the respondent's answer or the entered value is wrong. In this chapter, the decisive phrase is identify the survey field before interpreting the alert. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A value of 7 is rejected, but the student does not know whether the field is age, satisfaction or household size.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. read the column heading
- 2. match the question number
- 3. identify unit and data type
- 4. protect respondent identity
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Field identification supports databases and laboratory records. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Excel can show an input message when the cell is selected, describing expected type or range before an error occurs.
Stop, Warning and Information alerts have different enforcement strength, so the available buttons are part of the meaning. In this chapter, the decisive phrase is read the input message before typing. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The learner ignores Enter 1–5 and types the full phrase Very satisfied.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. select the cell
- 2. read the input title and message
- 3. compare it with the questionnaire
- 4. enter the documented code
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Pre-entry guidance supports forms and applications. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft gives each alert style different behavior. The icon and buttons reveal whether the rule blocks, challenges or merely informs.
Data validation protects typed entry imperfectly: copied, filled or inherited values can require a separate dataset audit. In this chapter, the decisive phrase is distinguish stop, warning and information. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A Warning alert is treated as an absolute prohibition even though a documented exception should be accepted.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. name the alert style
- 2. read every button label
- 3. state what each choice does
- 4. avoid clicking Yes or OK reflexively
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Control-state reading supports safety systems and permissions. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
The rule may require whole numbers, decimals, dates, times, text length, a list or a custom formula, with minimum and maximum boundaries.
The survey codebook owns the intended meaning of categories, missing values and exceptional cases; a spreadsheet prompt should implement that meaning, not silently rewrite it. In this chapter, the decisive phrase is read the validation condition. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A date is rejected because the cell expects a serial within the survey period, not free text.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. open Data Validation settings if authorised
- 2. name the condition
- 3. read boundaries and operators
- 4. compare with the field definition
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Rule reading supports programming and policy. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
The codebook defines how answers, missing values, refusals and not-applicable cases are represented.
A validation warning reports a rule mismatch; it does not automatically prove that the respondent's answer or the entered value is wrong. In this chapter, the decisive phrase is compare the rule with the survey codebook. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The worksheet allows 0–5, while the codebook reserves 0 for Missing and 1–5 for responses.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. locate the current codebook
- 2. match every allowed value
- 3. check missing-value conventions
- 4. flag discrepancies to the owner
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Schema alignment supports research and data careers. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A mistyped 55 in a 1–5 scale differs from a documented response outside an expected range. The evidence and remedy differ.
Stop, Warning and Information alerts have different enforcement strength, so the available buttons are part of the meaning. In this chapter, the decisive phrase is separate transcription error from legitimate exception. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A respondent's age is 102, but the validation maximum is 99 because the form designer assumed a narrower population.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. recheck the source record
- 2. protect participant privacy
- 3. classify error or exception
- 4. use the authorised exception note
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Exception handling supports medicine, finance and public policy. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Cleaning should not erase the original observation. Keep an authorised raw field or source record and record transformations separately.
Data validation protects typed entry imperfectly: copied, filled or inherited values can require a separate dataset audit. In this chapter, the decisive phrase is preserve the raw response before recoding. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A free-text answer is replaced by the nearest category without keeping the respondent's words.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. preserve the raw value
- 2. apply the documented code
- 3. record the recoding rule
- 4. retain reviewer approval
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Provenance supports reproducible research. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A list can distinguish exact category text; leading spaces, punctuation and visually similar labels can create unintended categories.
The survey codebook owns the intended meaning of categories, missing values and exceptional cases; a spreadsheet prompt should implement that meaning, not silently rewrite it. In this chapter, the decisive phrase is handle list entries and spaces carefully. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Yes and Yes with a trailing space become separate values in later counts.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. use the dropdown when supplied
- 2. compare exact labels
- 3. avoid manual variants
- 4. standardise only through the approved rule
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Exact-string reading supports coding and databases. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft says validation messages do not appear when users copy or fill data. A clean entry session can therefore hide invalid pasted values.
A validation warning reports a rule mismatch; it does not automatically prove that the respondent's answer or the entered value is wrong. In this chapter, the decisive phrase is understand copied data bypass risk. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Survey results are pasted from another sheet and no warnings appear, although several codes fall outside the allowed list.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. audit pasted ranges
- 2. use Circle Invalid Data
- 3. compare category counts
- 4. check the source mapping
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Import auditing supports analytics and finance. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft documents Circle Invalid Data for values that fail the current rule, including existing entries that did not trigger alerts.
Stop, Warning and Information alerts have different enforcement strength, so the available buttons are part of the meaning. In this chapter, the decisive phrase is circle inherited invalid data. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The workbook received validation after data collection, so old errors remain silent.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. select the intended range
- 2. run Circle Invalid Data
- 3. review each circle against source evidence
- 4. clear circles only after review
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Exception visualization supports quality assurance. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Validation can depend on formulas or reference cells. Microsoft notes that formula errors and changed references can interfere with validation behavior.
Data validation protects typed entry imperfectly: copied, filled or inherited values can require a separate dataset audit. In this chapter, the decisive phrase is check formulas and referenced cells. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A category list points to the wrong named range after a sheet is copied.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. inspect the formula or source list
- 2. check referenced cells
- 3. resolve formula errors
- 4. retest one allowed and one disallowed value
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Dependency tracing supports spreadsheets and software. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A valid cell can still be wrong for the respondent, and a dataset of individually valid cells can still have impossible combinations or biased missingness.
The survey codebook owns the intended meaning of categories, missing values and exceptional cases; a spreadsheet prompt should implement that meaning, not silently rewrite it. In this chapter, the decisive phrase is verify dataset-level meaning. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Every age is within range, but several rows pair Primary 1 with age 18 because columns shifted during import.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. check cross-field rules
- 2. run frequency tables
- 3. inspect missingness
- 4. sample records against source forms
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Dataset reasoning supports evidence-based decisions. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Record field, rule, alert style, source value, chosen action, codebook reference, reviewer and downstream check.
A validation warning reports a rule mismatch; it does not automatically prove that the respondent's answer or the entered value is wrong. In this chapter, the decisive phrase is write a validation decision receipt. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A later analyst sees an accepted invalid value but cannot tell whether it was an error or an approved exception.
The useful response is to separate what the interface proves, what the user intends and what the responsible institution permits. Those three layers often agree, but they are not interchangeable. A button can be available without being authorised for an assessment, and a sensible educational aim can still use the wrong file, device or scope.
- 1. quote the rule
- 2. preserve the source evidence
- 3. state correction or exception
- 4. record verification
After entry, audit the exact worksheet for invalid circles, out-of-range values, unexpected blanks, copied entries, category counts and codebook consistency before using the dataset for charts, percentages or conclusions. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Write a one-minute field note with the visible label, the access or data involved, the responsible person, the action taken and the evidence that would change the decision. This keeps explanation proportional: it is detailed enough for a teacher, parent or support person to reproduce the reasoning, but it does not copy private content into a new place. If the note uses a stronger verb than the interface or official source, revise the note. Precise English should narrow uncertainty rather than decorate it.
Transfer: Data documentation supports study, research and work. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
Four useful discoveries
Identify the survey field before interpreting the alert
The column heading, question number, respondent row and data type establish what the cell is meant to represent.
Boundary: A heading can be abbreviated; use the current codebook and questionnaire.
Read the input message before typing
Excel can show an input message when the cell is selected, describing expected type or range before an error occurs.
Boundary: Input messages can be outdated or hidden, so they are not the only authority.
Distinguish Stop, Warning and Information
Microsoft gives each alert style different behavior. The icon and buttons reveal whether the rule blocks, challenges or merely informs.
Boundary: A permissive button does not make an entry methodologically valid.
Read the validation condition
The rule may require whole numbers, decimals, dates, times, text length, a list or a custom formula, with minimum and maximum boundaries.
Boundary: Protected or shared workbooks may prevent viewing or changing settings.
Practice with realistic decisions
Compare the rule with the survey codebook
The worksheet allows 0–5, while the codebook reserves 0 for Missing and 1–5 for responses.
- locate the current codebook
- match every allowed value
- check missing-value conventions
- flag discrepancies to the owner
Separate transcription error from legitimate exception
A respondent's age is 102, but the validation maximum is 99 because the form designer assumed a narrower population.
- recheck the source record
- protect participant privacy
- classify error or exception
- use the authorised exception note
Preserve the raw response before recoding
A free-text answer is replaced by the nearest category without keeping the respondent's words.
- preserve the raw value
- apply the documented code
- record the recoding rule
- retain reviewer approval
Advice for students, families and educators
For students
- Read the alert style and codebook before choosing Yes, No, Retry or Cancel.
- Audit copied values because validation prompts may not appear.
For families
- Encourage careful source checking rather than forcing unusual answers into expected categories.
- Protect respondent privacy while seeking help.
For educators
- Publish a codebook with missing and exceptional values.
- Teach Circle Invalid Data and dataset-level checks after entry.
Frequently asked questions
What does a Stop alert do?
It prevents the invalid value from being entered until the user retries or cancels.
Can Warning accept an invalid value?
Yes; Microsoft documents Yes to accept, No to edit and Cancel to remove the entry.
What does Information mean?
It informs the user and can allow the value after dismissal.
Does a warning prove the response is wrong?
No; compare the rule with the source and codebook.
Why did pasted data show no alert?
Microsoft says copied or filled data may bypass validation messages.
How do I find existing invalid data?
Use Circle Invalid Data and audit the marked cells.
Can I change the rule?
Only with workbook-owner and research-protocol authority.
Should I overwrite an unusual response?
No; verify and preserve raw evidence before approved recoding.
What should be checked before analysis?
Invalid values, blanks, copied ranges, category counts, formulas and cross-field consistency.
Why English?
Because invalid, allowed, warning, accept and exception encode different evidence and actions.
Useful next reading
- Inconsistent-Formula Warning — audit a calculation after data entry
- Number Stored as Text — separate appearance from data type
- Why English Matters in Singapore — connect data literacy to education and careers
Closing thought
Precise English makes a digital state visible. Name the object, preserve the exact verb, respect authority, choose the smallest suitable action and verify the result that another person will actually receive.