CES CES Data Validation & Error Handling 2 — Questions and Answers
Question 1: Which Excel function returns TRUE if a cell contains an error value?
- ISBLANK
- ISERROR (Correct answer)
- ISNUMBER
- ISTEXT
Correct answer: ISERROR
ISERROR returns TRUE for any error type including #VALUE!, #REF!, #DIV/0!, and others.
Question 2: What is the purpose of 'Circle Invalid Data' in the Data tab?
- Highlights cells with formulas
- Draws red circles around cells that violate Data Validation rules (Correct answer)
- Marks duplicate values
- Outlines merged cells
Correct 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.
Question 3: Which function returns a number corresponding to the type of error in a cell?
- IFERROR
- ERROR.TYPE (Correct answer)
- ISERR
- TYPE
Correct answer: ERROR.TYPE
ERROR.TYPE returns an integer (1–8) that identifies which specific error exists in the referenced cell.
Question 4: A Data Validation rule is set to allow whole numbers between 1 and 100. Which entry will trigger an error?
- 50
- 100
- 0 (Correct answer)
- 1
Correct answer: 0
The value 0 is outside the range of 1 to 100 and will trigger the configured error alert.
Question 5: What does the #VALUE! error typically indicate?
- A circular reference exists
- The wrong type of argument is used in a formula (Correct answer)
- A referenced range is invalid
- A name is not recognized
Correct 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.
Question 6: Which Excel feature highlights cells based on rules, helping visually identify data entry errors?
- Data Validation
- Conditional Formatting (Correct answer)
- Sparklines
- Data Bars
Correct answer: Conditional Formatting
Conditional Formatting applies visual cues like colors or icons to cells that meet specified conditions, aiding error identification.
CES CES Data Validation & Error Handling 2
Which Excel function returns TRUE if a cell contains an error value?