Podcast
Questions and Answers
What is the purpose of selecting 'Stop' under the Error Alert tab in the Data Validation dialog box?
What is the purpose of selecting 'Stop' under the Error Alert tab in the Data Validation dialog box?
- To display a warning message without preventing the entry of invalid values
- To allow users to enter incorrect data
- To prevent users from entering incorrect data (correct)
- To remove all data validation settings
What should be typed in the Message box when setting up a 'Stop' Error Alert?
What should be typed in the Message box when setting up a 'Stop' Error Alert?
- Must be a number greater than 0.00 (correct)
- Must be a whole number
- Must be a text value
- Must be a negative number
How can Data Validation be removed from a range of cells?
How can Data Validation be removed from a range of cells?
- By changing the cell formatting
- By selecting individual cells and deleting the validation rules
- By selecting the range, opening the dialog box, and choosing 'Clear All' (correct)
- By copying and pasting cells to remove validation
What happens if you select 'Warning' under the Style options in the Error Alert tab?
What happens if you select 'Warning' under the Style options in the Error Alert tab?
When opening the Data Validation dialog box after selecting all cells in a table, why might you get an error message?
When opening the Data Validation dialog box after selecting all cells in a table, why might you get an error message?
What is the purpose of selecting 'Stop' under the Error Alert tab in Data Validation?
What is the purpose of selecting 'Stop' under the Error Alert tab in Data Validation?
What happens if a value of -25 is entered in a cell with 'Stop' Error Alert?
What happens if a value of -25 is entered in a cell with 'Stop' Error Alert?
What is the purpose of the Clear All button in the Data Validation dialog box?
What is the purpose of the Clear All button in the Data Validation dialog box?
When selecting all cells in a table and opening the Data Validation dialog box, what message might you receive?
When selecting all cells in a table and opening the Data Validation dialog box, what message might you receive?
What is the purpose of setting up an 'Input Message' in Data Validation?
What is the purpose of setting up an 'Input Message' in Data Validation?
