CES Data Validation & Error Handling Flashcards
6 cards from real CES practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 CES Data Validation & Error Handling flashcards as text
Which Excel feature restricts cell input to a specific list of values?
Answer: Data Validation
Data Validation with the List option restricts a cell to only accept values from a defined list.
What error value does Excel display when a formula references an empty cell that is expected to contain a number?
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.
Which function can be used to trap errors and return a custom value instead?
Answer: IFERROR
IFERROR evaluates an expression and returns a specified value if the expression results in any error.
In Data Validation, which setting allows you to display a message before the user enters data?
Answer: Input Message
The Input Message tab in Data Validation displays a tooltip-style message when the cell is selected, before entry.
What does the #DIV/0! error indicate in Excel?
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.
Which Data Validation option prevents any invalid entry and shows an error message without allowing override?
Answer: Stop
The Stop alert style in Data Validation blocks the entry entirely and requires the user to re-enter a valid value.