CES CES Data Validation & Error Handling 1 — Questions and Answers
Question 1: Which Excel feature restricts cell input to a specific list of values?
- Conditional Formatting
- Data Validation (Correct answer)
- Data Consolidate
- Flash Fill
Correct answer: Data Validation
Data Validation with the List option restricts a cell to only accept values from a defined list.
Question 2: What error value does Excel display when a formula references an empty cell that is expected to contain a number?
- #VALUE!
- #REF!
- #N/A (Correct answer)
- #NULL!
Correct answer: #N/A
#N/A indicates that a value is not available, often when a lookup finds no match in an empty or mismatched range.
Question 3: Which function can be used to trap errors and return a custom value instead?
- IFERROR (Correct answer)
- ISERROR
- ERROR.TYPE
- ISNA
Correct answer: IFERROR
IFERROR evaluates an expression and returns a specified value if the expression results in any error.
Question 4: In Data Validation, which setting allows you to display a message before the user enters data?
- Error Alert
- Input Message (Correct answer)
- Stop Alert
- Circle Invalid Data
Correct answer: Input Message
The Input Message tab in Data Validation displays a tooltip-style message when the cell is selected, before entry.
Question 5: What does the #DIV/0! error indicate in Excel?
- A formula references a deleted cell
- A value is divided by zero or an empty cell (Correct answer)
- Two ranges do not intersect
- A text value is used in a numeric formula
Correct answer: A value is divided by zero or an empty cell
#DIV/0! appears whenever a formula attempts to divide a number by zero or by a blank cell.
Question 6: Which Data Validation option prevents any invalid entry and shows an error message without allowing override?
- Warning
- Information
- Stop (Correct answer)
- Caution
Correct answer: Stop
The Stop alert style in Data Validation blocks the entry entirely and requires the user to re-enter a valid value.
CES CES Data Validation & Error Handling 1
Which Excel feature restricts cell input to a specific list of values?