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

It displays a warning but allows invalid data entry

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

When you select "Warning" style in the Error Alert tab, it displays a warning but allows invalid data entry.

Data validation is a feature to define restrictions on type of data entered into a cell. We can configure data validation rules for cells data that will not allow users to enter invalid data, There may be warning messages when users tries to type wrong data in the cell. The messages also guide users to what input is expected for the cell, and instructions to correct any errors. To set the response settings when invalid data is entered into the cell click on the third tab of data validation option i.e. Error Alert Tab. This tab enables :

(a) To display the error alert after invalid data is entered in the box.

(b) Enter message allows to type the desired message for user and title for reference purpose.

(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.