Stephanie Added Data Validation to a Worksheet Column After Entering

question 338

Multiple Choice

Stephanie added data validation to a worksheet column after entering a few records of data.Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

• A) Tracer Arrows
• B) Error Check
• C) Watch Window
• D) Circle Invalid Data

---

Definitions:

Real-time Processing

Computing that processes data as it is received, ensuring immediate output and responses.

Data Redundancy

The duplication of data in multiple places within a database or information storage system, often to increase reliability or improve performance.

Normalization

The process of organizing the fields and tables of a database to minimize redundancy and dependency.

Exporting

The act of sending goods or services to another country for sale or trade.