Accountancy Part CSpreadsheet

What happens when you select "Warning" style in the Error Alert tab?

Answer & explanation

Correct answer: option 2

The correct answer is Option (2) → It displays a warning but allows invalid data entry

The Error Alert tab of data validation decides what Excel does when a user types data that breaks the rule. It offers three styles, from the mildest to the strictest: Information, Warning and Stop. The Warning style shows a message but still lets the user keep the invalid entry if he chooses to.

Why the other options are incorrect

Option (1) It stops invalid data from being entered — Incorrect. Blocking the entry is what the Stop style does, not the Warning style.
Option (3) It ignores invalid data entry silently — Incorrect. Every error alert style shows a message; none of them accepts wrong data without a word.
Option (4) It deletes the invalid data entered — Incorrect. Data validation never deletes what was typed; it only warns or refuses the entry.

NCERT (2026-27 edition):
Data Validation – “… (c) In Style drop-down menu select Information, Warning or Stop as per the severity and accuracy requirement for data where. (i) Information: displays a message but will prevent entry of invalid data. (ii) Warning: displays a warning message but will not prevent entry of invalid data. (iii) Stop: will prevent invalid entry of data.”