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 function returns TRUE if a cell contains an error value?
Answer: ISERROR
ISERROR returns TRUE for any error type including #VALUE!, #REF!, #DIV/0!, and others.
What is the purpose of 'Circle Invalid Data' in the Data tab?
Answer: Draws red circles around cells that violate Data Validation rules
Circle Invalid Data draws red ovals around any cells that currently contain values outside the defined validation criteria.
Which function returns a number corresponding to the type of error in a cell?
Answer: ERROR.TYPE
ERROR.TYPE returns an integer (1–8) that identifies which specific error exists in the referenced cell.
A Data Validation rule is set to allow whole numbers between 1 and 100. Which entry will trigger an error?
Answer: 0
The value 0 is outside the range of 1 to 100 and will trigger the configured error alert.
What does the #VALUE! error typically indicate?
Answer: The wrong type of argument is used in a formula
#VALUE! appears when a formula receives an argument of the wrong data type, such as text where a number is expected.
Which Excel feature highlights cells based on rules, helping visually identify data entry errors?
Answer: Conditional Formatting
Conditional Formatting applies visual cues like colors or icons to cells that meet specified conditions, aiding error identification.