Asked by Gildardo Ramos on Jun 17, 2024

verifed

Verified

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

Data Validation

A feature in spreadsheet software that allows users to set specific criteria for the type of data that can be entered into a cell, ensuring accuracy and consistency in data entry.

Circle Invalid

A function in data validation that visually identifies data that does not comply with certain predefined criteria.

Error Check

The process or mechanism within a system or software that identifies, reports, and sometimes corrects errors to ensure data integrity and operational stability.

  • Comprehend the fundamentals of data validation and the monitoring of errors within Excel.
verifed

Verified Answer

CK
Christina KearnsJun 22, 2024
Final Answer :
D
Explanation :
The Circle Invalid Data feature will highlight all cells in the worksheet that do not meet the criteria of the data validation for easy identification and correction.