CES CES Data Validation & Error Handling 2

Question 1

Which Excel function returns TRUE if a cell contains an error value?

Accepted Answer

ISERROR

Answer

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?

Accepted Answer

Draws red circles around cells that violate Data Validation rules

Answer

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?

Accepted Answer

ERROR.TYPE

Answer

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?

Accepted Answer

0

Answer

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?

Accepted Answer

The wrong type of argument is used in a formula

Answer

#VALUE! appears when a formula receives an argument of the wrong data type, such as text where a number is expected.

CES - Certified Excel Specialists Practice Test