CES CES Data Validation & Error Handling

Question 1

Which Excel feature restricts cell input to a specific list of values?

Accepted Answer

Data Validation

Answer

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?

Accepted Answer

#N/A

Answer

#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?

Accepted Answer

IFERROR

Answer

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?

Accepted Answer

Input Message

Answer

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?

Accepted Answer

A value is divided by zero or an empty cell

Answer

#DIV/0! appears whenever a formula attempts to divide a number by zero or by a blank cell.

CES - Certified Excel Specialists Practice Test