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

Conditional Formatting

Answer

Data Consolidate

Answer

Flash Fill

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

#VALUE!

Answer

#REF!

Answer

#NULL!

Question 3

Which function can be used to trap errors and return a custom value instead?

Accepted Answer

IFERROR

Answer

ISERROR

Answer

ERROR.TYPE

Answer

ISNA

Question 4

In Data Validation, which setting allows you to display a message before the user enters data?

Accepted Answer

Input Message

Answer

Error Alert

Answer

Stop Alert

Answer

Circle Invalid Data

Question 5

What does the #DIV/0! error indicate in Excel?

Accepted Answer

A value is divided by zero or an empty cell

Answer

A formula references a deleted cell

Answer

Two ranges do not intersect

Answer

A text value is used in a numeric formula

Question 6

Which Data Validation option prevents any invalid entry and shows an error message without allowing override?

Accepted Answer

Stop

Answer

Warning

Answer

Information

Answer

Caution